SQL Reporting Services and Internet Enabled Reports
Posted on 2006-07-13
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!!!