?
Solved

VB.Net ReportServer application  authentication error

Posted on 2011-02-16
1
Medium Priority
?
794 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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

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…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses

743 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