Solved

SQL Reporting Services and Internet Enabled Reports

Posted on 2006-07-13
2
352 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 500 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

763 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