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: , ,

 Print | Posted on Saturday, June 02, 2007 10:26 AM | Filed Under [ Visual Studio Web Development Miscellaneous ]


Feedback

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

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

12/11/2007 2:34 PM | Adam Wolf

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

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.

2/8/2008 11:24 AM | Dan McCann

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

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?

3/1/2008 4:22 PM | Timothy Elvidge

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

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 :)

3/2/2008 9:07 PM | Ross Hawkins

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

Man!!!!!!!!thank you

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

3/5/2008 12:16 PM | Marwan

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

Man!!!!!!!!thank you

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

3/5/2008 12:16 PM | Marwan

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

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...

4/10/2008 8:29 AM | Sridhern

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

Thanks! This solution worked for me too.


Happy Reporting

8/8/2008 9:01 AM | Edgardo Morales

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

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.

8/28/2008 7:30 AM | Tony

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

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

8/28/2008 8:10 AM | Tony

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

thanks!!!!!!!

9/2/2008 9:57 PM | srou

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

fixed me up on Vista

9/3/2008 2:58 AM | JLM

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

Hi Ross,

Thank you very much.
It helped me alot.

Thanks and Regards
Ratna
www.mygemnetwork.com

9/25/2008 10:49 PM | Ratna Sekhar mygemnetwork

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

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.

11/3/2008 7:32 AM | William

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

thanks ross, it was very hepfull

12/31/2008 6:11 AM | Rene Huamani

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

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

3/4/2009 2:58 PM | mani

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

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.

3/6/2009 2:54 PM | James Knowlton

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

Your solution of adding the handler mapping works great! Thanks

5/28/2009 2:49 AM | Josh King

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

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

6/18/2009 5:40 AM | Hari

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

Thanks a lot!!

very usefull!!

12/18/2009 5:46 AM | angel

Gravatar

# re: SQL Server Web Report Viewer Issues on Longhorn/IIS7

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.

12/26/2009 7:04 PM | www.web-casino-craps.com/

Post Comment

Title  
Name  
Email
Website / Url
 

Your comment

   
Please add 7 and 7 and type the answer here:

About me

My name is Ross Hawkins and I'm a Developer, Consultant and Writer based in Auckland, New Zealand (pictured below!). My current work revolves around ASP.NET, C#, jQuery, Ajax, SQL Server, and a mix of other Microsoft development technologies.

I also have about 14 years of experience with IBM Lotus Notes/Domino and associated technologies. While Notes/Domino is no longer my primary focus I still like to dabble and keep my skills up to date.

I own and run 2 businesses - Hawkins Consulting Services, and Ignition Development.

Bethells Beach, located in sunny West Auckland, New Zealand


Subscribe

Subscribe to this feed


Search


Popular Content

Troubleshooting WebResource.axd

The .NET 2.0 framework changed the way clientside JavaScript is delivered to the browser. Previously, ASP.NET 1.1 used the aspnet_client directory whereas now 2.0 uses WebResource.axd.

Published on October 8, 2006

Microsoft AJAX Extensions: Sys.Debug is null or not an object

One of the breaking changes which was made with the 1.0 release of the Microsoft Ajax Extensions was the renaming of the 'Debug' class to 'Sys.Debug' for reasons of compatiability with other frameworks. Breaking changes like this can often be a source of frustration..

Published on May 22, 2007

Simple ASP.NET Character Counter

A textbox character counter is a pretty simple piece of functionality, and there's a lot of different ways to apply one to your application. The following method is nice and simple, and can be done using only clientside JavaScript if required, or combined with server side code in order to create a more dynamic effect

Published on December 4, 2006

Simple ASP.NET Character Counter - with Master Page Support

A quick update to my previous character counter article adding some changes for those using it with Master Pages.

Published on February 7th, 2009

Adding Tooltips to Gridview Headers

As the title says, this is a very simple but dynamic way of achieving tooltip text on a header column. It's not overly flash, but it's lightweight and quick to implement.

Published on April 15, 2007

SQL Server Web Report Viewer Issues on Windows 2008 Server/IIS7

A fix for another AXD related issue, this time with the SQL Server Web Report Viewer Control which was being served up via IIS7 on a Windows 2008 server.

Published on June 2, 2007
Updated on April 10, 2008


Archives

March, 2010 (3)
February, 2010 (6)
January, 2010 (12)
December, 2009 (13)
November, 2009 (11)
October, 2009 (12)
September, 2009 (12)
August, 2009 (2)
July, 2009 (7)
June, 2009 (12)
May, 2009 (9)
April, 2009 (9)
March, 2009 (9)
February, 2009 (8)
January, 2009 (7)
December, 2008 (6)
November, 2008 (7)
October, 2008 (9)
September, 2008 (12)
August, 2008 (9)
July, 2008 (6)
June, 2008 (24)
May, 2008 (13)
April, 2008 (16)
March, 2008 (8)
February, 2008 (10)
January, 2008 (1)
December, 2007 (14)
November, 2007 (11)
October, 2007 (11)
September, 2007 (13)
August, 2007 (11)
July, 2007 (5)
June, 2007 (15)
May, 2007 (11)
April, 2007 (9)
March, 2007 (9)
February, 2007 (10)
January, 2007 (8)
December, 2006 (18)
November, 2006 (11)
October, 2006 (14)
September, 2006 (9)
August, 2006 (10)
July, 2006 (4)
June, 2006 (4)
May, 2006 (6)
April, 2006 (3)
February, 2006 (6)
January, 2006 (10)
September, 2005 (2)
August, 2005 (4)

Post Categories

ASP.NET
AJAX
Amusing
NZ
NZ Trains
Notes/Domino
Visual Studio
Web Development
Miscellaneous
Me
Rugby
C#
SQL


Twitter