Reporting Services Returning HTTP 401 Unauthorized
- by Chris Arnold
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!