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.
No comments:
Post a Comment