Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 815
  • Last Modified:

VB.Net ReportServer application authentication error

.NET - SSRS 2008 R2 - ReportExecution2005.asmx - 401: Unauthorized

I have reconfigured an existing (previously non-operational) SSRS installation and upgraded it to SSRS 2008 R2. It is running on Windows Server 2003 R2 alongside the MSSQL database which is hosting the ReportServer and ReportServerTempDB databases, as well as another database which contains application data to be reported on. The server is called AHTEST.

The SSRS ReportingServiceService.exe is running as the NT Authority\NETWORK SERVICE.

We have a VB.Net ReportServer application which monitors a report request table within the application database, submits report requests to SSRS and handles the returned output.

The configuration has worked to the point that I am able to impersonate the user (which is a local user on the server: AHTEST\HMP_ReportServer) to produce report output via the (interactive) Report Manager (which uses the standard SSRS URL: http://ahtest/Reports) through a browser.

BUT, when I attempt to submit the report requests in code (via http://ahtest/ReportServer/ReportExecution2005.asmx), I receive a “The request failed with HTTP status 401: Unauthorized.” System.Net.WebException.

I have tried everything I can think of in terms of IIS authentication (but could easily have missed something).

And I have tried anything that I could make sense of out of the following articles for SSRS authentication, without any luck either:
•      http://support.microsoft.com/kb/871179
•      http://www.sqldev.org/sql-server-reporting-services/http-401-error-when-calling-reportexecution2005-from-web-service-hosted-on-same-machine-24228.shtml
•      http://msdn.microsoft.com/en-us/library/ms159272(v=SQL.105).aspx
•      http://msdn.microsoft.com/en-us/library/bb522727(v=SQL.105).aspx
•      http://msdn.microsoft.com/en-us/library/ff487479.aspx

Any help would be greatly appreciated.
1 Solution
lcohanDatabase AnalystCommented:
My personal feeling is that it won't work no matter what you do unless the user will be a domain user and not just a local user. We went to similar pain and path to let employees access SSRS reports via Report Manager and nothing other NT domain users worked. In our case we could not use a custom form authentication because it works with either integrated or forms but not both at the same time and we couldn't develop one quick enough. I think is worth to try with one user which is real NT domain user not just local user but this will not solve your(or mine) problem but (unfortunately) just prove that Microsoft documentation is right in this case.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now