Solved

SQL Reporting Services and Internet Enabled Reports

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

624 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