jscrime
asked on
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!!!
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'
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!!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER