The request failed with HTTP status 401: Unauthorized.
I have a report created that works in when I run locally, but when I deploy it to the hosted report server it works when I access it on the report server. When I run it from my application using a report viewer I get "The request failed with HTTP status 401: Unauthorized.". Any suggestions? Thanks!
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Check under which account your Asp.Net application works and that account got provisioned to execute the report.
Some of the reason to cause 401 are
Check with the below steps for configuration of Windows Authentication
http://msdn.microsoft.com/en-us/library/cc281253(v=sql.100).aspx
check this URL, whether is it helps with your infrastructure
http://www.codeproject.com/Questions/148974/Sql-2008-Report-server-Error-HTTP-status-401-Unaut
Some of the reason to cause 401 are
User is not authorized with the Report Server.
May be Reporting Services is configured to use Kerberos, where as the Service Principal Name(SPN) is not registered for the account under Reporting Services is running.
Check with the below steps for configuration of Windows Authentication
http://msdn.microsoft.com/en-us/library/cc281253(v=sql.100).aspx
check this URL, whether is it helps with your infrastructure
http://www.codeproject.com/Questions/148974/Sql-2008-Report-server-Error-HTTP-status-401-Unaut
Premium Content
You need an Expert Office subscription to comment.Start Free Trial