Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Reporting Services and Internet Enabled Reports

Posted on 2006-07-13
2
Medium Priority
?
355 Views
Last Modified: 2008-01-09
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
Comment
Question by:jscrime
[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
2 Comments
 
LVL 41

Accepted Solution

by:
ralmada earned 1500 total points
ID: 17102874
Pls

In IIS try to uncheck the anonymous login and check the Basic Aunthetication
0
 

Author Comment

by:jscrime
ID: 17103781
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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

730 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