SQL Server Web Report Viewer Issues on Longhorn/IIS7

It seems I've come across yet another AXD related issue. This time with the SQL Server Web Report Viewer Control which was being served up via IIS7 on a Longhorn server. As soon as the page loaded I was getting JavaScript errors of 'RSClientController is undefined'. The report had been working fine on development boxes, so I was pretty sure it was either related to the deployment or IIS.

In checking the source of the page I found the following entry: <script src="/Reserved.ReportViewerWebControl.axd? OpType=Resource&amp;Version=8.0.50727.817&amp;Name=Scripts.ReportViewer.js" type="text/javascript"></script>

Which of course didn't exist when I pasted the URL into a browser.

The fix for my environment: In IIS Manager, I added a new handler mapping for Reserved.ReportViewerWebControl.axd (Sites\Your WebSite\Handler Mappings, create new mapping) and set it to type Microsoft.Reporting.WebForms.HttpHandler. Without thinking about this too much, it looks like without an explicit mapping for Reserved.ReportViewerWebControl.axd, it matches the default *.axd mapping which (as you'd expect) doesn't work.

I'm not sure if the setup for the Report Web Control is different for IIS7 compared to IIS6, as I've not found any postings talking about fixing this problem in this way. In fact most of them seem to have fixed the issue by modifying the *.axd handler and deselecting 'Verify File Exists' which was already set correctly in my case.

 

[Updated 10/04/2008] - I'm adding a quick and current screenshot from our box which is running the RTM version of Server 2008 for those of you who were having trouble following my post. I wrote the original post almost a year ago, and I'm not sure whether a few things in the IIS Admin UI were moved/renamed over that time, causing confusion.

So in IIS Manager, navigate to Your Website\Handler Mappings, then Right click and "Add Managed Handler". It should end up looking something similar to this:

 

Tags: , ,

Posted on Saturday, June 2, 2007 10:26 AM | Visual Studio Web Development Miscellaneous

Like this? Share it!

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 12/11/2007 2:34 PM

    Thank you, this post saved me some time ---no alot of time. Thank you for your time. adam

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 2/8/2008 11:24 AM

    Your fixed worked for me too. I used ProcessMonitor and from the looks of things the Reserved.ReportViewerWebControl.axd does not match the *.axd handler. IIS actually attempt to find the file on the local file system. Maybe it's the extra '.' that causes it not to match the wildcard.

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 3/1/2008 4:22 PM

    I have the same problem on an IIS7 box running on RC1 Windows 2008. I am not able to follow your instructions. What sort of mapping is the new mapping - Script Map or Module map? If its a script map which executeable should be handling the request. I have checked the web config in the reportserver directory and it has the appropriate handlers defined. What am I missing?

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 3/2/2008 9:07 PM

    Tim,

    Check my (much) earlier post here:

    http://www.rosshawkins.net/archive/2006/10/08/webresource.axd.aspx

    While this talks about issues with IIS 6 and Server 2003, it should give you all the background info you need to get the mapping sorted. If you're still having problems, drop me an email - always happy to help a fellow kiwi :)

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 3/5/2008 12:16 PM

    Man!!!!!!!!thank you

    works like a charm, this is on a Vista Box. You are a life saver.

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 3/5/2008 12:16 PM

    Man!!!!!!!!thank you

    works like a charm, this is on a Vista Box. You are a life saver.

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 4/10/2008 8:29 AM

    I have the same problem on an IIS7 box running on RC1 Windows 2008. I am not able to follow your instructions. What sort of mapping is the new mapping - Script Map or Module map? If its a script map which executeable should be handling the request. I have checked the web config in the reportserver directory and it has the appropriate handlers defined. What am I missing? Please email me...

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 8/8/2008 9:01 AM

    Thanks! This solution worked for me too.


    Happy Reporting

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 8/28/2008 7:30 AM

    Same issue as Sridhern :

    "I have the same problem on an IIS7 box running on RC1 Windows 2008. I am not able to follow your instructions. What sort of mapping is the new mapping - Script Map or Module map? If its a script map which executeable should be handling the request. I have checked the web config in the reportserver directory and it has the appropriate handlers defined. What am I missing?"

    Any answer is appreciated.

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 8/28/2008 8:10 AM

    Never mind with my question. I was messed up with the "Reports" site.

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 9/2/2008 9:57 PM

    thanks!!!!!!!

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 9/3/2008 2:58 AM

    fixed me up on Vista

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 9/25/2008 10:49 PM

    Hi Ross,

    Thank you very much.
    It helped me alot.

    Thanks and Regards
    Ratna
    www.mygemnetwork.com

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 11/3/2008 7:32 AM

    Thanks a lot! I am running SQL 2008 express and Visual Web developer 2008 Express and it worked for me too, so that I am able to display reports over IIS and not just in the development environment. If you'd like a free login to my DecisionSupport website, let me know.

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 12/31/2008 6:11 AM

    thanks ross, it was very hepfull

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 3/4/2009 2:58 PM

    thank you so much....your post helped me save a lot of time.

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 3/6/2009 2:54 PM

    Thanks! This was exactly the problem and your detailed help was most appreciated. I was able to Add the mapping exactly as you had it pictured and everything started working. Thanks again.

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 5/28/2009 2:49 AM

    Your solution of adding the handler mapping works great! Thanks

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 6/18/2009 5:40 AM

    Thank you -- this nailed it.
    Life saver...thank you...

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 12/18/2009 5:46 AM

    Thanks a lot!!

    very usefull!!

  • # re: SQL Server Web Report Viewer Issues on Longhorn/IIS7
    Gravatar
    Commented on 12/26/2009 7:04 PM

    The nucleus core is lightweight which makes it pretty fast, but not fast enough for my sluggish server though. It still makes a lot of SQL queries and has to read and parse templates which takes a lot of time.

Post a comment
Please add 1 and 3 and type the answer here:
Remember me?
Ensure the word in this box says 'orange':