When I try to connect to RS through SQL management I get this...
TITLE: Connect to Server
Cannot connect to UKCINT\UKCAZOSQL.
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 />
<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>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.2047.00" target="_blank">Get Online Help</a></li><ul>
<li>Could not load type 'Microsoft.Web.Services.ScriptHandlerFactory'. (c:\inetpub\wwwroot\web.config line 45)</li><ul>
<li>Could not load type 'Microsoft.Web.Services.ScriptHandlerFactory'.</li>
</ul>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.SqlServer.Management.UI.RSClient)
BUTTONS:
OK
I can connect to other services and Reporting Services has worked in the past. I have tried to directly connect through the web browser and it works fine.
Thanks for any suggestions.
I encountered the same error as well. The environment is SQL Server 2005 on Windows 2003 Server. Looking for the cause and a solution.|||I had this problem also. It turned out I had installed SSRS with an account without enough privilages. I re-installed with a account with higher privilages on the server and it worked.
Hope this helps!
|||The only change I made was we recently installed BizTalk to try it out. I wonder if that did something to cause this problem.|||I uninstalled the BizTalk and still the same error message. I am getting this message from both the direct RS server and a remote client connecting to the server and now all of our reports on our intranet are getting the same error message.
Should I just reinstall Reporting Services?
The error that I am getting trying to connect from a remote machine is: "No Connection could be made because the target machine actively refused it (server)."
|||I don't know if I found the solution, however I am now able to connect. What I did is to comment out the following lines in the web.config file that resides in the wwwroot folder for IIS:
<!--
<httpHandlers>
<remove verb="*" path="*.asmx"/>
<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
<add verb="*" path="*.asmx" type="Microsoft.Web.Services.ScriptHandlerFactory" validate="false"/>
</httpHandlers>
-->
UPDATE: Actually, this did not work. This has allowed my SQL Management Studio to now connect to Reporting Services, but our intranet is giving me more error messages:
The Report Viewer Web Control HTTP Handler has not been registered in the application's web.config file. Add <add verb="*" path="Reserved.ReportViewerWebControl.axd" type = "Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> to the system.web/httpHandlers section of the web.config file.
|||More information:
This problem is driving me nuts. I checked out the Configure Report Server on another machine and the box next to Initialization is check, however greyed-out. For the server instance that is actually having the problem this box is X'ed out and greyed out even though the application says that this instance has been started.
