Geek Answers Handbook

Problem viewing report after switching to a new server

I just moved the site from a Windows 2003 server, IIS6 SQL 2005 to a new one with Windows 2008, IIS7 and SQL 2008.

I'm having problems with the report viewer. I installed Report Viewer Re-distributable (I tried 2005, 2005sp, 2008 and 2008sp) I mapped the handler in IIS for

Reserved.ReportViewerWebControl.axd

enter

Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version = 8.0.0.0, Culture = Neutral, PublicKeyToken = b03f5f7f11d50a3a

However, whenever I run a report on a website, I get the following error message:

Failed to load type "Microsoft.Reporting.Microsoft.Reporting.WebForms.HttpHandler" from the assembly "Microsoft.ReportViewer.WebForms, Version = 9.0.0.0, Culture = neutral, PublicKeyToken = b03f5f7f11d50a3a". Description: An unhandled exception occurred during the execution of the current web request. Check the stack trace for more information about the error and where it appeared in the code.

Exception Details: System.TypeLoadException: Failed to load type "Microsoft.Reporting.Microsoft.Reporting.WebForms.HttpHandler" from the assembly "Microsoft.ReportViewer.WebForms, Version = 9.0.0.0, Culture = neutral, PublicKeyToken = b03f5f7f11d50a3a".

I'm at a dead end. Any ideas?

+4
source share
6 answers

I think you need to map version 9.0.0.0, not 8.0.0.0

+1
source

you need to make sure that this parameter must be in your real web.config server

<compilation debug="true"> <assemblies> </assemblies> <buildProviders> <add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/> </buildProviders> 

  <httpHandlers> <add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/> </httpHandlers>
+1
source

If you are running IIS 7, it is worth checking that the handler also has permission to execute.

After installing the mine, I saw that the handler just throws an exception of 500, upon closer examination it seems that just adding a handler to the list is not enough. You must also edit its permission, because by default it is not allowed to execute. Touching the drawer so that it runs, and immediately solved my problem.

+1
source

It may also be useful to try this if any other suggestions do not work here -

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/0152bb52-988d-43f5-9c3d-8d33512f46de/

"There were a number of issues with the transition to IIS 7. Significant debugging required.

FIRST RELEASE RESOLVED: directory rights for the IIS 7 pool identifier (the default was Network Service), which must be added that the IIS application pool can access the physical directory path of the website.

SECOND ISSUE RESOLVED: The string must be added to the ASP.Net web.config application file. Baby after

Added:

THIRD QUESTION RESOLVED. The default application pool during installation has .Net Framework 2.0 by default. It was wonderful. The default application pool setting for managed pipeline mode needs to be changed from Integrated (default) to Classic, it was a quick fix that allowed my application to work as it did in IIS 6 ".

Changing the managed conveyor mode to "classic" fixed it for me.

+1
source

It looks like this problem has been resolved for a while, but for anyone looking:

Pay attention to the link referenced by the error:

 Microsoft.Reporting.Microsoft.Reporting.WebForms.HttpHandler

It should just be Microsoft.Reporting.WebForms.HttpHandler - as we both ended up with being suspicious in our web.config but may have something to do with manually creating the handler in IIS and letting IIS write the handler key to the web application .config (now, of course, I cannot play it).

For those moving to IIS7, remember that now the handler mapping is now in <system.webServer> <handlers> , and not <system.web> <httpHandlers> , as it was in earlier versions. IIS7 ignores the old httpHandlers section, but you can check the settings out of habit there and be disappointed that your settings did not take effect.

0
source

Just include CommanClassLibrary.dll in your Bin Folder project and make sure the version of ReportViewer Web Control on the aspx page and configuration file is the same

0
source

More articles:


All Articles