Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 356
  • Last Modified:

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!!!

 
0
jscrime
Asked:
jscrime
1 Solution
 
ralmadaCommented:
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

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Tackle projects and never again get stuck behind a technical roadblock.
Join Now