Reporting Services Returning HTTP 401 Unauthorized

Posted by Chris Arnold on Server Fault See other posts from Server Fault or by Chris Arnold
Published on 2010-04-09T19:04:31Z Indexed on 2010/04/09 19:13 UTC
Read the original article Hit count: 1085

Filed under:
|
|

I have just ported an existing ASP.NET application to a new web server (Windows Server 2008 R2 and SQL Server 2008). It is successfully running on 4 other servers of varying O/S (which I also setup).

My ASP.NET app calls into the Reporting Services Web Service (ReportExecution2005.asmx) to generate a report and save it as a pdf to the file system. I consistently receive "System.Net.WebException - The request failed with HTTP status 401: Unauthorized."

In UTTER desperation I have performed the following...

  • Granted all Users complete access to SSRS via the Reports web page.
  • Granted all Users 'Full control' to <%ProgramFiles%>\Microsoft SQL Server\MSRS10.MSSQLSERVER

I am not a network / server specialist but I'm the only one that can deal with this and it's driving me batty. Help!

© Server Fault or respective owner

Related posts about iis7

Related posts about reporting-services