Solved

VB.Net ReportServer application  authentication error

Posted on 2011-02-16
1
768 Views
Last Modified: 2012-05-11
.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.
0
Comment
Question by:pancho15
1 Comment
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 34910435
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.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question