I have posted this to the general SQL Server group but without any response. I have also searched all of the forums and have not found an answer. For some reason all of a sudden, my Reporting Services is failing with this message when trying to connect:
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.1399.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.1399.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 have now uninstalled SQL Reporting Services, reinstalled it, but I am still getting the same error. From what I can infer, there is a problem with the httpHandler in the web.config file. It cannot load Microsoft.Web.Services.ScriptHandlerFactory.
Does anybody know anything about this or what else I might need to check? This has been going on for two days now and short of totally uninstalling all of SQL, I don't know what to do.
Thanks.
Update, I just uninstalled and reinstalled Reporting Services and SQL and still the same error. Any help will be greatly appreciated.|||You'll need to escape the mapping for that httpHandler. Try adding this to the end of your web.config. It basically resets the handler for asmx back to the default one used by asp.net 2.0.<location path="ReportServer">
<system.web>
<httpHandlers>
<remove verb="*" path="*.asmx"/>
<add path="*.asmx" verb="*" type="System.Web.Services.Protocols.WebServiceHandlerFactory, System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="False" />
</httpHandlers>
<httpModules>
<remove name="ScriptModule" />
<remove name="BridgeModule" />
<remove name="WebResourceCompression" />
</httpModules>
<pages theme=""/>
</system.web>
</location>
<location path="ReportManager">
<system.web>
<httpHandlers>
<remove verb="*" path="*.asmx"/>
<add path="*.asmx" verb="*" type="System.Web.Services.Protocols.WebServiceHandlerFactory, System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="False" />
</httpHandlers>
<httpModules>
<remove name="BridgeModule" />
<remove name="ScriptModule" />
<remove name="WebResourceCompression" />
</httpModules>
<pages theme=""/>
</system.web>
</location>
|||Thanks for the response. I copied and added this to the end of the web.config file and I am still getting the same error.|||
Make sure my virtual directories match the names you are using. We are not using the standard name for ReportManager, I think the default is Reports. Also, make sure you put this outside <system.web> node. I think you would get an error if you don't, but it doesn't hurt to check.
cs
|||Yep, made sure that the virtual directories are the same. Should I try to rename them and then try it that way? We are using ReportServer$Instance and Reports$Instance. So I assuming that I need to use ReportServer and Reports (without the $Instance). I am still getting the same error message.|||You should use the same names you see when you look at your site in IIS Manager. Honestly, I'm really surprised you are still getting the same error since those config entries effectively back out whatever is in your web.config in the application above your virtual directories. Do your Reporting Services virtual directories exist inside another asp.net 2.0 atlas application? The error you are seeing is an Atlas related issue.cs
|||
I was testing Atlas and I was also afraid that might be the issue too. This is my current web.config file (and I am afraid that I have made a mess of it). I wish there was a button that said "Restore to Default". Forgive my naivety when it comes to this. With all of the changes and deletions, I know now that I am missing something needed. I am sure it is in the HTTPHandlers section.
<?xml version="1.0"?>
<configuration>
<configSections>
<sectionGroup name="microsoft.web" type="Microsoft.Web.Configuration.MicrosoftWebSectionGroup">
<section name="converters" type="Microsoft.Web.Configuration.ConvertersSection"/>
<section name="webServices" type="Microsoft.Web.Configuration.WebServicesSection" />
<section name="authenticationService" type="Microsoft.Web.Configuration.AuthenticationServiceSection" />
<section name="profileService" type="Microsoft.Web.Configuration.ProfileServiceSection" />
</sectionGroup>
</configSections>
<connectionStrings>
<clear />
connections strings taken out
</connectionStrings>
<system.web>
<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"/>
</httpHandlers>
<membership defaultProvider="UKCSQLMembershipProvider" userIsOnlineTimeWindow="15">
<providers>
<remove name="AspNetSqlMembershipProvider"/>
<add name="UKCSQLMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="UKCAZOSQLServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="3" passwordAttemptWindow="10" passwordStrengthRegularExpression=""/>
</providers>
</membership>
<roleManager defaultProvider="UKCSQLRoleProvider" enabled="true" cacheRolesInCookie="true" cookieName=".ASPXROLES" cookiePath="/" cookieTimeout="30" cookieRequireSSL="false" cookieSlidingExpiration="true" createPersistentCookie="true" cookieProtection="All">
<providers>
<remove name="AspNetSqlRoleProvider"/>
<remove name="AspNetWindowsTokenRoleProvider"/>
<add connectionStringName="UKCAZOSQLServer" applicationName="/" name="UKCSQLRoleProvider" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
</providers>
</roleManager>
<profile defaultProvider="UKCSQLProfileProvider">
<providers>
<remove name="AspNetSqlProfileProvider"/>
<add name="UKCSQLProfileProvider" connectionStringName="UKCAZOSQLServer" applicationName="/" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
</providers>
</profile>
<compilation debug="true" strict="false" explicit="true">
<buildProviders>
<add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
</buildProviders>
</compilation>
<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
<pages>
<namespaces>
<add namespace="System"/>
<add namespace="System.Collections"/>
<add namespace="System.Collections.Specialized"/>
<add namespace="System.Configuration"/>
<add namespace="System.Text"/>
<add namespace="System.Text.RegularExpressions"/>
<add namespace="System.Web"/>
<add namespace="System.Web.Caching"/>
<add namespace="System.Web.SessionState"/>
<add namespace="System.Web.Security"/>
<add namespace="System.Web.Profile"/>
<add namespace="System.Web.UI"/>
<add namespace="System.Web.UI.WebControls"/>
<add namespace="System.Web.UI.WebControls.WebParts"/>
<add namespace="System.Web.UI.HtmlControls"/>
</namespaces>
</pages>
<authentication mode="Forms"/>
<customErrors mode="Off"/>
</system.web>
<location path="ReportServer">
<system.web>
<httpHandlers>
<remove verb="*" path="*.asmx"/>
<add path="*.asmx" verb="*" type="System.Web.Services.Protocols.WebServiceHandlerFactory, System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</httpHandlers>
<httpModules>
<remove name="ScriptModule" />
<remove name="BridgeModule" />
<remove name="WebResourceCompression" />
</httpModules>
<pages theme=""/>
</system.web>
</location>
<location path="Reports">
<system.web>
<httpHandlers>
<remove verb="*" path="*.asmx"/>
<add path="*.asmx" verb="*" type="System.Web.Services.Protocols.WebServiceHandlerFactory, System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</httpHandlers>
<httpModules>
<remove name="BridgeModule" />
<remove name="ScriptModule" />
<remove name="WebResourceCompression" />
</httpModules>
<pages theme=""/>
</system.web>
</location>
</configuration>
|||what error are you getting again?|||
This is the exact error on the page that holds the ReportViewer control.
It is now working! I cleaned out a lot of garbage and essentially redid web.config.
I thank you for your help.
|||Hi there,
I'm getting the same error. What did you clean out the web.config file to get it working?
|||Hi,
I have some problems with you. Can you tell me how to fix it?
Thanks !
Katie
No comments:
Post a Comment