I now is using asp.net (vbscript) and SQL 2005 Reporting Services.
I have create a report from SQL Server Business Intelligence Development Studio, on the sql report application is work, but after I plug-into reportviewer show me below message.
use Remote mode
The request failed with HTTP status 401: Unauthorized.
for Local mode
A data source instance has not been supplied for the data source 'databasename'.
Hi,
I have just installed MSRS 2005 & created & deployed a report at Http://<MySrvr>/ReportServer & report path is RerportProject/SampleReport
using VS 2005 I just dragged & dropped the report viewer control on a web page & set the properties as follows
ServerReport -> ReportPath = RerportProject/SampleReport and ReportServerUrl = Http://<MySrvr>/ReportServer and when I run this page I am getting this error "The request failed with HTTP status 401: Unauthorized.",
I've also tried with writing the following code in the page load event
ReportViewer1.ServerReport.ReportPath = "/ReportingProject/EmpReport";
ReportViewer1.ServerReport.ReportServerUrl =new Uri("http://cs042/ReportServer");
even this is causing tha same problem
I even tried this solution
1. Click Start, click Run, type regedit, and then click OK.
2. In Registry Editor, locate and then click the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
3. Right-click Lsa, point to New, and then click DWORD Value.
4. Type DisableLoopbackCheck, and then press ENTER.
5. Right-click DisableLoopbackCheck, and then click Modify.
6. In the Value data box, type 1, and then click OK.
7. Quit Registry Editor, and then restart your computer.
but it still not working.
I've worked on MSRS 2000 also so I added the old ReportViewer control on to my webpage with that the report is displayed fine, i dont under stand why the reportviewer control of 2005 is causing problem
I'm trying to display a RS report deployed on a remote SQL server in a Report viewer control..
I can succesfully call the report from
http://SQLSERVER/Reports/Folder/The_report
I've set the ReportServerUrl to http://SQLSERVER/reports and the ReportPath property to : /TestRSReport/webstats_H_A_B
but still no success even after applying the tricks mentioned above in this thread...
Yes I've done it. You just need to add
identity impersonate = true in the web.config, that's it..
Both my web server and the SSRS Server's Virtual Directory "ReportServer" is already <identity impersonate = true>
Still fail, what can i do???? HELP!!!!!!!!!!!!!
Regards
Ken Lin, Kam Hung
MCP, MCP+I, MCDST, MCSA, MCSE, MCSE+I, MCDBA, MCSD, MCAD, MCITP
Microsoft Community Star (Hong Kong & Taiwan)
Microsoft MVP, MCT
VB Insider, SourceCode K2 Insider
Inserting <identity impersonate="true" /> tag in web.config works well if my web application is running on my local web server. But it fails when I run the web application from a remote web server.
I had to grant Browser permission to the web server account ID at the item-level security of the report. And this works well now.
Hey, thats right, when i set tag identity impersonate="true" in web config, it just work as well when i browse the report in my local web server. But not work when i browsed it in client. Can you tell me how to grant Browser permission to the web server
account ID at the item-level security?
fong01
Member
65 Points
13 Posts
The request failed with HTTP status 401: Unauthorized.
Apr 25, 2006 08:01 AM|LINK
Hi,
I now is using asp.net (vbscript) and SQL 2005 Reporting Services.
I have create a report from SQL Server Business Intelligence Development Studio, on the sql report application is work, but after I plug-into reportviewer show me below message.
use Remote mode
The request failed with HTTP status 401: Unauthorized.
for Local mode
-
A data source instance has not been supplied for the data source 'databasename'.
thkandyrivera25...
Member
19 Points
3 Posts
Re: The request failed with HTTP status 401: Unauthorized.
May 02, 2006 08:45 PM|LINK
The solution is here http://www.taznetworks.com/rss/2006/03/crm-30-sbe-sql-reporting-error.html
and / or here http://support.microsoft.com/default.aspx?scid=kb;en-us;896861
This was driving me crazy so I am posting the answer everywhere I saw someeone else asking and getting no answers.
adonis
Member
260 Points
52 Posts
Re: The request failed with HTTP status 401: Unauthorized.
May 09, 2006 08:38 AM|LINK
I have just installed MSRS 2005 & created & deployed a report at Http://<MySrvr>/ReportServer & report path is RerportProject/SampleReport
using VS 2005 I just dragged & dropped the report viewer control on a web page & set the properties as follows
ServerReport -> ReportPath = RerportProject/SampleReport and ReportServerUrl = Http://<MySrvr>/ReportServer and when I run this page I am getting this error "The request failed with HTTP status 401: Unauthorized.",
I've also tried with writing the following code in the page load event
ReportViewer1.ServerReport.ReportPath = "/ReportingProject/EmpReport";
ReportViewer1.ServerReport.ReportServerUrl =new Uri("http://cs042/ReportServer");
even this is causing tha same problem
I even tried this solution
1. Click Start, click Run, type regedit, and then click OK.
2. In Registry Editor, locate and then click the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
3. Right-click Lsa, point to New, and then click DWORD Value.
4. Type DisableLoopbackCheck, and then press ENTER.
5. Right-click DisableLoopbackCheck, and then click Modify.
6. In the Value data box, type 1, and then click OK.
7. Quit Registry Editor, and then restart your computer.
but it still not working.
I've worked on MSRS 2000 also so I added the old ReportViewer control on to my webpage with that the report is displayed fine, i dont under stand why the reportviewer control of 2005 is causing problem
Adonis
adonis
Member
260 Points
52 Posts
Re: The request failed with HTTP status 401: Unauthorized.
May 09, 2006 12:36 PM|LINK
Adonis
Leketje
Member
611 Points
122 Posts
Re: The request failed with HTTP status 401: Unauthorized.
Sep 28, 2006 12:50 PM|LINK
Hello,
I'm trying to display a RS report deployed on a remote SQL server in a Report viewer control..
I can succesfully call the report from http://SQLSERVER/Reports/Folder/The_report
I've set the ReportServerUrl to http://SQLSERVER/reports and the ReportPath property to : /TestRSReport/webstats_H_A_B
but still no success even after applying the tricks mentioned above in this thread...
Any idea??
KenLin2000
Member
6 Points
4 Posts
Re: The request failed with HTTP status 401: Unauthorized.
Dec 21, 2006 08:44 AM|LINK
Both my web server and the SSRS Server's Virtual Directory "ReportServer" is already <identity impersonate = true>
Still fail, what can i do???? HELP!!!!!!!!!!!!!
Ken Lin, Kam Hung
MCP, MCP+I, MCDST, MCSA, MCSE, MCSE+I, MCDBA, MCSD, MCAD, MCITP
Microsoft Community Star (Hong Kong & Taiwan)
Microsoft MVP, MCT
VB Insider, SourceCode K2 Insider
tnafoo
Member
19 Points
16 Posts
Re: The request failed with HTTP status 401: Unauthorized.
Oct 10, 2007 03:44 AM|LINK
all i did was added <identity impersonate = true /> within <system.web> tag in web.config file. and now it's working!
Tamer Fathy
Participant
1174 Points
225 Posts
Re: The request failed with HTTP status 401: Unauthorized.
Oct 10, 2007 03:59 AM|LINK
What you need to do is to impersonate using a user gain browse privileges on the reporting server
check this link http://support.microsoft.com/kb/306158
http://www.odetocode.com/Articles/156.aspx
MCAD .NET
http://tamer-fathy.blogspot.com/
tnafoo
Member
19 Points
16 Posts
Re: The request failed with HTTP status 401: Unauthorized.
Oct 22, 2007 03:42 AM|LINK
Inserting <identity impersonate="true" /> tag in web.config works well if my web application is running on my local web server. But it fails when I run the web application from a remote web server.
I had to grant Browser permission to the web server account ID at the item-level security of the report. And this works well now.
initial_D
Member
10 Points
5 Posts
Re: The request failed with HTTP status 401: Unauthorized.
Nov 15, 2007 12:43 AM|LINK
Hey, thats right, when i set tag identity impersonate="true" in web config, it just work as well when i browse the report in my local web server. But not work when i browsed it in client. Can you tell me how to grant Browser permission to the web server account ID at the item-level security?