Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 07, 2011 07:41 PM by rogeriomurari
Apr 25, 2006 08:01 AM|LINK
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
May 02, 2006 08:45 PM|LINK
The solution is here
and / or here
This was driving me crazy so I am posting the answer everywhere I saw someeone else asking and getting no answers.
May 09, 2006 08:38 AM|LINK
May 09, 2006 12:36 PM|LINK
Sep 28, 2006 12:50 PM|LINK
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
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...
Dec 21, 2006 08:44 AM|LINK
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!!!!!!!!!!!!!
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!
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
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.
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?