Friday, February 17, 2012

Error after sp2 install

After installing sp2 on my production server ( went well in dev and qa) I got
this message:
Client found response content type of 'text/html; charset=utf-8', but
expected 'text/xml'. The request failed with the error message: -- <html>
<head> <title> SQL Server Reporting Services </title><meta name="Generator"
content="Microsoft SQL Server Reporting Services 9.00.2047.00" /> <meta
name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9"
/> <meta name="CountryLocaleID" content="1033" /> <meta name="StackTrace"
content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
at
Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String
configFileName, String configLocation) at
Microsoft.ReportingServices.Library.Global.get_ConfigurationManager() at
Microsoft.ReportingServices.WebServer.Global.StartApp() at
Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object
sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana;
FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana;
FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal;
FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana;
FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt;
FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE:
8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline} A:visited
{FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1>
Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul>
<li>The report server has encountered a configuration error. See the report
server log files for more information. (rsServerConfigurationError) </li><ul>
<li>Access to the path 'C:\Program Files\Microsoft SQL
Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is
denied.</li> </ul> </ul><hr width="100%" size="1" color="silver" /><span
class="ProductInfo">SQL Server Reporting Services</span> </body> </html> --.
I'd really appriciate help on this!!
FredHaving same problem, any solution?
"Fred" wrote:
> After installing sp2 on my production server ( went well in dev and qa) I got
> this message:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'. The request failed with the error message: -- <html>
> <head> <title> SQL Server Reporting Services </title><meta name="Generator"
> content="Microsoft SQL Server Reporting Services 9.00.2047.00" /> <meta
> name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9"
> /> <meta name="CountryLocaleID" content="1033" /> <meta name="StackTrace"
> content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
> at
> Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String
> configFileName, String configLocation) at
> Microsoft.ReportingServices.Library.Global.get_ConfigurationManager() at
> Microsoft.ReportingServices.WebServer.Global.StartApp() at
> Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object
> sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana;
> FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana;
> FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal;
> FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana;
> FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt;
> FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE:
> 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline} A:visited
> {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul>
> <li>The report server has encountered a configuration error. See the report
> server log files for more information. (rsServerConfigurationError) </li><ul>
> <li>Access to the path 'C:\Program Files\Microsoft SQL
> Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is
> denied.</li> </ul> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">SQL Server Reporting Services</span> </body> </html> --.
> I'd really appriciate help on this!!
> Fred|||Me too!
Browser window error:
â?¢ The report server has encountered a configuration error. See the report
server log files for more information. (rsServerConfigurationError)
o Access to the path 'c:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is
denied.
<Header>
<Product>Microsoft SQL Server Reporting Services Version
9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Standard Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\LogFiles\ReportServer__03_08_2007_15_56_35.log</Path>
<SystemName>TESS-RCREPS</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
aspnet_wp!webserver!1!3/8/2007-15:56:37:: i INFO: Reporting Web Server started
aspnet_wp!diagnostic!1!3/8/2007-15:56:37:: Error loading configuration file:
Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\RSReportServer.config' is denied.
aspnet_wp!library!1!3/8/2007-15:56:38:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information. -->
System.UnauthorizedAccessException: Access to the path 'c:\Program
Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\RSReportServer.config' is denied.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess
access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize,
FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean
bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess
access, FileShare share)
at
Microsoft.ReportingServices.Diagnostics.Globals.SafeOpenXmlDocumentFile(XmlDocument doc, String pathToXmlFile)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.LoadDocument()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
-- End of inner exception stack trace --
aspnet_wp!diagnostic!1!3/8/2007-15:56:38:: Error loading configuration file:
Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\RSReportServer.config' is denied.
aspnet_wp!library!1!3/8/2007-15:56:38:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information. -->
System.UnauthorizedAccessException: Access to the path 'c:\Program
Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\RSReportServer.config' is denied.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess
access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize,
FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean
bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess
access, FileShare share)
at
Microsoft.ReportingServices.Diagnostics.Globals.SafeOpenXmlDocumentFile(XmlDocument doc, String pathToXmlFile)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.LoadDocument()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
-- End of inner exception stack trace --
"Joe S." wrote:
> Having same problem, any solution?
> "Fred" wrote:
> > After installing sp2 on my production server ( went well in dev and qa) I got
> > this message:
> >
> > Client found response content type of 'text/html; charset=utf-8', but
> > expected 'text/xml'. The request failed with the error message: -- <html>
> > <head> <title> SQL Server Reporting Services </title><meta name="Generator"
> > content="Microsoft SQL Server Reporting Services 9.00.2047.00" /> <meta
> > name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9"
> > /> <meta name="CountryLocaleID" content="1033" /> <meta name="StackTrace"
> > content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String
> > configFileName, String configLocation) at
> > Microsoft.ReportingServices.Library.Global.get_ConfigurationManager() at
> > Microsoft.ReportingServices.WebServer.Global.StartApp() at
> > Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object
> > sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana;
> > FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana;
> > FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal;
> > FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana;
> > FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt;
> > FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE:
> > 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline} A:visited
> > {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
> > A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> > TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1>
> > Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul>
> > <li>The report server has encountered a configuration error. See the report
> > server log files for more information. (rsServerConfigurationError) </li><ul>
> > <li>Access to the path 'C:\Program Files\Microsoft SQL
> > Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is
> > denied.</li> </ul> </ul><hr width="100%" size="1" color="silver" /><span
> > class="ProductInfo">SQL Server Reporting Services</span> </body> </html> --.
> >
> > I'd really appriciate help on this!!
> >
> > Fred|||Deleting encrypted content in RS configuration fixed this for us.|||I got my RS working again. Originally my IIS 6.0 was running in 32 bit mode
for the RS. The SP2 upgrade it appears changed the RS to need 64 bit for
which the OS and SQL are both running. By changing IIS not to run 32 bit apps
the RS web pages appeared again.
"Fred" wrote:
> After installing sp2 on my production server ( went well in dev and qa) I got
> this message:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'. The request failed with the error message: -- <html>
> <head> <title> SQL Server Reporting Services </title><meta name="Generator"
> content="Microsoft SQL Server Reporting Services 9.00.2047.00" /> <meta
> name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9"
> /> <meta name="CountryLocaleID" content="1033" /> <meta name="StackTrace"
> content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
> at
> Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String
> configFileName, String configLocation) at
> Microsoft.ReportingServices.Library.Global.get_ConfigurationManager() at
> Microsoft.ReportingServices.WebServer.Global.StartApp() at
> Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object
> sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana;
> FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana;
> FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal;
> FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana;
> FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt;
> FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE:
> 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline} A:visited
> {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul>
> <li>The report server has encountered a configuration error. See the report
> server log files for more information. (rsServerConfigurationError) </li><ul>
> <li>Access to the path 'C:\Program Files\Microsoft SQL
> Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is
> denied.</li> </ul> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">SQL Server Reporting Services</span> </body> </html> --.
> I'd really appriciate help on this!!
> Fred
Posted by feudp at 7:15 AM
Labels: , , , , , , , , , , , , , , , , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)