I'm working through Ch 3 of "SQL Server 2005 Reporting Services Step by Step" by Stacia Misner, published by Microsoft Press, but I can't get the example report in Ch3 to deploy. I get a long error message, which says this:
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://localhost/ReportServer.
ADDITIONAL INFORMATION:
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.RSConfiguration.Construct(String configFileName)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)
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.3\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>
--. (Microsoft.ReportingServices.Designer)
BUTTONS:
OK
This is your problem:
<li>Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>
Looks like the account that SSRS is running under doesn't have permissions on \ReportServer. Make sure the account in question can read from the folder.
|||Thanks, but it still doesn't work even with admin permissions. I restarted IIS and RS and that reduced the error to the following:
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://localhost/ReportServer.
ADDITIONAL INFORMATION:
Unable to connect to the remote server (Microsoft.ReportingServices.Designer)
No connection could be made because the target machine actively refused it (System)
BUTTONS:
OK|||
I went to the Surface Area Configuration for Features and Reporting Services is enabled. But when I select "Windows Integrated Security" I get this error:
TITLE: Surface Area Configuration
Unable to connect to the remote server (System)
ADDITIONAL INFORMATION:
No connection could be made because the target machine actively refused it (System)
BUTTONS:
OK|||I should mention that I have SQL Server 2005 installed on my machine and am trying to deploy to it. I'm not working over a net.|||
Hey Roger,
Did you ever find a solution or cause to your problem? I am now experiencing the same problem.
I am not trying to deploy a report, rather install SQL 2005 SP1, which fails stating I could not authenticate to all instances. Then, when poking around in the Surface Area Configuration Manager, clicking on SQL Server Reporting Services - Windows Integrated Security, I get the same error you get:
"Unable to connect to remote server (System)"
"A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond (System)"
Thanks!
Dan
