error dump file

Hi,
Our production server had frozen suddenly (it was working=20
for years without any issues), and I noticed sql server=20
error dump file afterwards(see below). I think that=20
process SPID 60 caused the problem, but I'm not sure how=20
to find out what was SPID before the "accident". Is=20
it "SELECT" statement which can be seen in the first part=20
of dump file?
SqlDumpExceptionHandler: Process 60 generated fatal=20
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server=20
is terminating this process..
*=20
************************************************** ********
*********************
*
* BEGIN STACK DUMP:
* 09/01/04 06:37:00 spid 60
*
* Exception Address =3D 004766C1 (CMemManager::ReleaseOS=20
+ 0000003A Line 0+00000000)
* Exception Code =3D c0000005=20
EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000008
* s p _ e x e c u 0d 00 73 00 70 00 5f 00 65 00 78 00=20
65 00 63 00 75 00
* t e s q l =E7 74 00 65 00 73 00 71 00 6c 00 02=20
00 00 00 e7 a2 13 09
* 4 S E L E C T 04 d0 00 34 a2 13 53 00 45 00 4c 00=20
45 00 43 00 54 00
* T i c k e r , P 20 00 54 00 69 00 63 00 6b 00 65 00=20
72 00 2c 00 50 00
******* list of columns in the statement follows *****
Thanks in advance,
Baki
Generally yes. For AV's you should really contact PSS to help you diagnose
the issue.
http://support.microsoft.com/default...s;Prodoffer41a
You'll get your money back if it's a bug (and AV's generally are)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Baki" <anonymous@.discussions.microsoft.com> wrote in message
news:0aaa01c490f1$4402d190$a401280a@.phx.gbl...
Hi,
Our production server had frozen suddenly (it was working
for years without any issues), and I noticed sql server
error dump file afterwards(see below). I think that
process SPID 60 caused the problem, but I'm not sure how
to find out what was SPID before the "accident". Is
it "SELECT" statement which can be seen in the first part
of dump file?
SqlDumpExceptionHandler: Process 60 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process..
*
************************************************** ********
*********************
*
* BEGIN STACK DUMP:
* 09/01/04 06:37:00 spid 60
*
* Exception Address = 004766C1 (CMemManager::ReleaseOS
+ 0000003A Line 0+00000000)
* Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000008
* s p _ e x e c u 0d 00 73 00 70 00 5f 00 65 00 78 00
65 00 63 00 75 00
* t e s q l 74 00 65 00 73 00 71 00 6c 00 02
00 00 00 e7 a2 13 09
* 4 S E L E C T 04 d0 00 34 a2 13 53 00 45 00 4c 00
45 00 43 00 54 00
* T i c k e r , P 20 00 54 00 69 00 63 00 6b 00 65 00
72 00 2c 00 50 00
******* list of columns in the statement follows *****
Thanks in advance,
Baki

error dump file

Hi,
Our production server had frozen suddenly (it was working for years without any issues), and I noticed sql server error dump file afterwards(see below). I think that process SPID 60 caused the problem, but I'm not sure how to find out what was SPID before the "accident". Is it "SELECT" statement which can be seen in the first part of dump file?
SqlDumpExceptionHandler: Process 60 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
* **********************************************************
*********************
*
* BEGIN STACK DUMP:
* 09/01/04 06:37:00 spid 60
*
* Exception Address =3D 004766C1 (CMemManager::ReleaseOS + 0000003A Line 0+00000000)
* Exception Code =3D c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000008
* s p _ e x e c u 0d 00 73 00 70 00 5f 00 65 00 78 00 65 00 63 00 75 00
* t e s q l =E7 74 00 65 00 73 00 71 00 6c 00 02 00 00 00 e7 a2 13 09
* 4 S E L E C T 04 d0 00 34 a2 13 53 00 45 00 4c 00 45 00 43 00 54 00
* T i c k e r , P 20 00 54 00 69 00 63 00 6b 00 65 00 72 00 2c 00 50 00
******* list of columns in the statement follows *****
Thanks in advance,
BakiGenerally yes. For AV's you should really contact PSS to help you diagnose
the issue.
http://support.microsoft.com/default.aspx?scid=fh;en-us;Prodoffer41a
You'll get your money back if it's a bug (and AV's generally are)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Baki" <anonymous@.discussions.microsoft.com> wrote in message
news:0aaa01c490f1$4402d190$a401280a@.phx.gbl...
Hi,
Our production server had frozen suddenly (it was working
for years without any issues), and I noticed sql server
error dump file afterwards(see below). I think that
process SPID 60 caused the problem, but I'm not sure how
to find out what was SPID before the "accident". Is
it "SELECT" statement which can be seen in the first part
of dump file?
SqlDumpExceptionHandler: Process 60 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process..
*
**********************************************************
*********************
*
* BEGIN STACK DUMP:
* 09/01/04 06:37:00 spid 60
*
* Exception Address = 004766C1 (CMemManager::ReleaseOS
+ 0000003A Line 0+00000000)
* Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000008
* s p _ e x e c u 0d 00 73 00 70 00 5f 00 65 00 78 00
65 00 63 00 75 00
* t e s q l ç 74 00 65 00 73 00 71 00 6c 00 02
00 00 00 e7 a2 13 09
* 4 S E L E C T 04 d0 00 34 a2 13 53 00 45 00 4c 00
45 00 43 00 54 00
* T i c k e r , P 20 00 54 00 69 00 63 00 6b 00 65 00
72 00 2c 00 50 00
******* list of columns in the statement follows *****
Thanks in advance,
Baki

error dump file

Hi,
Our production server had frozen suddenly (it was working=20
for years without any issues), and I noticed sql server=20
error dump file afterwards(see below). I think that=20
process SPID 60 caused the problem, but I'm not sure how=20
to find out what was SPID before the "accident". Is=20
it "SELECT" statement which can be seen in the first part=20
of dump file?
SqlDumpExceptionHandler: Process 60 generated fatal=20
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server=20
is terminating this process..
*=20
****************************************
******************
*********************
*
* BEGIN STACK DUMP:
* 09/01/04 06:37:00 spid 60
*
* Exception Address =3D 004766C1 (CMemManager::ReleaseOS=20
+ 0000003A Line 0+00000000)
* Exception Code =3D c0000005=20
EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000008
* s p _ e x e c u 0d 00 73 00 70 00 5f 00 65 00 78 00=20
65 00 63 00 75 00
* t e s q l =E7 74 00 65 00 73 00 71 00 6c 00 02=20
00 00 00 e7 a2 13 09
* 4 S E L E C T 04 d0 00 34 a2 13 53 00 45 00 4c 00=20
45 00 43 00 54 00
* T i c k e r , P 20 00 54 00 69 00 63 00 6b 00 65 00=20
72 00 2c 00 50 00
******* list of columns in the statement follows *****
Thanks in advance,
BakiGenerally yes. For AV's you should really contact PSS to help you diagnose
the issue.
http://support.microsoft.com/defaul...us;Prodoffer41a
You'll get your money back if it's a bug (and AV's generally are)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Baki" <anonymous@.discussions.microsoft.com> wrote in message
news:0aaa01c490f1$4402d190$a401280a@.phx.gbl...
Hi,
Our production server had frozen suddenly (it was working
for years without any issues), and I noticed sql server
error dump file afterwards(see below). I think that
process SPID 60 caused the problem, but I'm not sure how
to find out what was SPID before the "accident". Is
it "SELECT" statement which can be seen in the first part
of dump file?
SqlDumpExceptionHandler: Process 60 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process..
*
****************************************
******************
*********************
*
* BEGIN STACK DUMP:
* 09/01/04 06:37:00 spid 60
*
* Exception Address = 004766C1 (CMemManager::ReleaseOS
+ 0000003A Line 0+00000000)
* Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000008
* s p _ e x e c u 0d 00 73 00 70 00 5f 00 65 00 78 00
65 00 63 00 75 00
* t e s q l 74 00 65 00 73 00 71 00 6c 00 02
00 00 00 e7 a2 13 09
* 4 S E L E C T 04 d0 00 34 a2 13 53 00 45 00 4c 00
45 00 43 00 54 00
* T i c k e r , P 20 00 54 00 69 00 63 00 6b 00 65 00
72 00 2c 00 50 00
******* list of columns in the statement follows *****
Thanks in advance,
Baki

Error connecting to Database - please help

When i am trying to connect to SQL Server(Express edition) on production server i am getting the following error.

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.)"
My SQL connection string is like this which i wrote in web.config.

<add key="conn1" value="Data Source=xxx.xxx.x.xx\xyz,1433;Initial Catalog=abcdef_xyz;persist Security Info=true;User ID=xx;Password=xxxxxx"/>

string constr = ConfigurationManager.AppSettings["conn1"];
SqlConnection con = new SqlConnection(constr);

con.Open();

When i searched microsoft help to resolve this error, it suggested me to enable TCP/IP protocol for SQL server, i did that, but even after doing that i am still not able to connect to the database. Could any one please tell me what else i need to configure in order to connect to the database.

Thanks

Can you connect with management studio express? It may be that your connection string is wrong..

|||

Hi tgopi99,

The error message indicates that the server is not reachable. Make sure you have specified the correct server name and also, make sure you can reach that ip address from your machine(do you have a firewall installed on your machine?)

Error between local development and production in a textbox

I have a textbox with the following:
=Fields!Distribution_Percentage.Value & "%"
It works fine on my local reportserver.
I deploy it to production and I get #Error instead.
I change it to
=Fields!Distribution_Percentage.Value
and it works fine on both except I want the % sign.
Since my numbers are like 100 or 25 instead of 1 or .25, I get the wrong
result if I select the Percent format for the textbox, 100,000%.
Any clues what is happening?
NeilUse the custom format and put in 0% I think that would do it. I used 0
instead of # because I assume that if it is 0 you want to show 0% instead of
just %
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Neil Gould" <NeilGould@.discussions.microsoft.com> wrote in message
news:5B5F6533-37DD-4A65-A0F4-737451563B71@.microsoft.com...
> I have a textbox with the following:
> =Fields!Distribution_Percentage.Value & "%"
> It works fine on my local reportserver.
> I deploy it to production and I get #Error instead.
> I change it to
> =Fields!Distribution_Percentage.Value
> and it works fine on both except I want the % sign.
> Since my numbers are like 100 or 25 instead of 1 or .25, I get the wrong
> result if I select the Percent format for the textbox, 100,000%.
> Any clues what is happening?
> Neil|||Thanks for replying but I didn't explain it well. At first I didn't have any
formatting specified. The # is part of the #Error displayed.
The real issue appears to be mixing field values.
In the header for this report, I have:
="From Fiscal " & Parameters!startdate.Value & " to " &
Parameters!enddate.Value
This also shows #Error on the prod server and shows the results expected
results locally. It sems to be complaining about mixing text and numeric
values.
The format for these textboxes is 'Default'. I wonder if there is some
configuration setting somewhere.
Thanks,
Neil
"Bruce L-C [MVP]" wrote:
> Use the custom format and put in 0% I think that would do it. I used 0
> instead of # because I assume that if it is 0 you want to show 0% instead of
> just %
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Neil Gould" <NeilGould@.discussions.microsoft.com> wrote in message
> news:5B5F6533-37DD-4A65-A0F4-737451563B71@.microsoft.com...
> > I have a textbox with the following:
> > =Fields!Distribution_Percentage.Value & "%"
> > It works fine on my local reportserver.
> > I deploy it to production and I get #Error instead.
> > I change it to
> > =Fields!Distribution_Percentage.Value
> > and it works fine on both except I want the % sign.
> > Since my numbers are like 100 or 25 instead of 1 or .25, I get the wrong
> > result if I select the Percent format for the textbox, 100,000%.
> >
> > Any clues what is happening?
> > Neil
>
>|||This should be working for you. I do this all the time. As a matter of fact,
you should also have no problems with appending a % on too.
When doing a string like this you do not need any formatting specified.
Ahh, just thought of something. Report parameters are case sensitive. What I
do is use the expression builder when doing this sort of thing.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Neil Gould" <NeilGould@.discussions.microsoft.com> wrote in message
news:F810CF36-FF22-4679-BAB1-82E26D6DE67C@.microsoft.com...
> Thanks for replying but I didn't explain it well. At first I didn't have
any
> formatting specified. The # is part of the #Error displayed.
> The real issue appears to be mixing field values.
> In the header for this report, I have:
> ="From Fiscal " & Parameters!startdate.Value & " to " &
> Parameters!enddate.Value
> This also shows #Error on the prod server and shows the results expected
> results locally. It sems to be complaining about mixing text and numeric
> values.
> The format for these textboxes is 'Default'. I wonder if there is some
> configuration setting somewhere.
> Thanks,
> Neil
>
> "Bruce L-C [MVP]" wrote:
> > Use the custom format and put in 0% I think that would do it. I used 0
> > instead of # because I assume that if it is 0 you want to show 0%
instead of
> > just %
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Neil Gould" <NeilGould@.discussions.microsoft.com> wrote in message
> > news:5B5F6533-37DD-4A65-A0F4-737451563B71@.microsoft.com...
> > > I have a textbox with the following:
> > > =Fields!Distribution_Percentage.Value & "%"
> > > It works fine on my local reportserver.
> > > I deploy it to production and I get #Error instead.
> > > I change it to
> > > =Fields!Distribution_Percentage.Value
> > > and it works fine on both except I want the % sign.
> > > Since my numbers are like 100 or 25 instead of 1 or .25, I get the
wrong
> > > result if I select the Percent format for the textbox, 100,000%.
> > >
> > > Any clues what is happening?
> > > Neil
> >
> >
> >

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