SQL Reporting Services and Internet Enabled Reports

The setup for my scenario is as follows:

Machine A (Report Server): Windows 2003 Server, SQL Server 2005, located in the domain
Machine B (Web Server): Windows 2003, IIS6, located in DMZ

Goal is to produce an application to display a report on the ReportServer over the internet.  All users can access the report with the same username and password and all other requirements are extremely basic.

I developed a VB.Net Web Application in VS.Net 2005
The main form consists of a web form with the built in ReportViewer control.
I have tried both 'Forms' and 'Windows' authentication in the web.config file, also Identity is set to Impersonate=True with username='domain\user' and password is set

When I run the application from debugger in vs.net I get the following: "Execution 'azzo3l55yopwmt552sljce45' cannot be found

If I deploy to live web server and access using http://www.domain.com/path/reportname.aspx I get the following error:  "The request failed with HTTP status 401: Unauthorized."

I have been on this for days trying all kinds of tricks, someways I can get the report to run locally but I have not been able to workaround the live scenario giving me the 401 access denied error.

If I am using impersonation and impersonating a user that can run the same report on the ReportServer, what am I missing in this scenario.  Somehow my credentials are not being used.

Thanks for your help on this issue!!!

 
jscrimeAsked:
Who is Participating?
 
ralmadaConnect With a Mentor Commented:
Pls

In IIS try to uncheck the anonymous login and check the Basic Aunthetication
0
 
jscrimeAuthor Commented:
With Anonymous access off and basic checked, the first thing to come up is a login/password screen.  At this point I assume my credentials are being sent.  Proceeding to fill in the username and password and clicking ok leads to the same 401 access denied screen.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.