I have an asp.net web application(which uses ReportViewer Control Version 8.0.0.0.) runs successfuly on VS2005/Windows Server 2008with Reporting Service 2005. I am able to view all reports on report viewer control in web application.
I ported the same project to VS2008with ReportViewer Control version 9.0.0.0 and Reporting Service 2008 on the same machine. Now both ReportViewer assemblies reside side by side in GAC.I have fully configured Reporting Service 2008.Data Source for the RS is SQL Server 2008.

When I try to view the report in report viewer control I get an error:-The request failed with HTTP status 401: Unauthorized.
The Error message in evetn viewer is as follow:-
Full Event Message: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID)
at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()

Both reports have same credentials everywhere.
In both the case I run my reports in remote mode and reports are deployed on local server.

In case of RS2005 report server Url is :- http://localhost/reportserver

In case of RS2008 reprot server Url is:- http://dev1:8080/ReportServer_MSSQLSERVER2008
I can view all reports on above server but I get error while viewing in Report Viewer Control.

Can anyone please help me as how to resolve the problme.
I would like to thank you for your help in advance.
Bharat.

---

bgadhia

I got this working.
I had to give permission to the same user(whose name is specified in "ReportViewerUser" section of web.config) to MSRS10.MSSQLSERVER2008 folder under C:\Program Files\Microsoft SQL Server. Also in web.config file add <identity impersonate= true>
Hope this helps some one who also face the same problme.

---

bgadhia

I got this working.
I had to give permission to the same user(whose name is specified in "ReportViewerUser" section of web.config) to MSRS10.MSSQLSERVER2008 folder under C:\Program Files\Microsoft SQL Server. Also in web.config file add <identity impersonate= true>
Hope this helps some one who also face the same problme.

---

bgadhia