Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

VB.Net ReportServer application  authentication error

Posted on 2011-02-16
1
Medium Priority
?
803 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 40

Accepted Solution

by:
lcohan earned 2000 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses

597 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