How to bypass the Reporting Services username & password prompt.

Posted on 2009-04-15
Medium Priority
Last Modified: 2012-08-13
I have a C#/asp.net web application that uses a report viewer control to
display a  Reporting Services report. When the asp.net page displays,
the applicatin user is prompted to enter a username and
password, and then to press a button labeled "View Report"
This will then display the report. Please see the attached screen snapshot.

The fact that the user has to enter in a username and password is not acceptable
according to the requirements. Hence, I need to figure out how the application
user can bypass having to enter in a username and password. The only way I can
figure out how to free the application user from entering in credentials, is to
programmaticaly with C# pass in the credentials.

Does anyone know how this can be done using C# ?
Question by:brgdotnet

Accepted Solution

newbieal earned 900 total points
ID: 24154262
Looks like your default.aspx page contains login-related controls.  You could strip the code of that or comment it out.

If you are saying that SQL Server is forcing to authenticate, than you need to set up a user in sql server for your asp .net application.

Not sure if I exactly understood the issue correct, but hope this helps somewhat.

Assisted Solution

SNilsson earned 600 total points
ID: 24157736
Use the interface for reporting services server\reportspath with an admin account.
Configure the datasource with a sql server account under 'stored securely on sql server...'
Make sure you bind the report to that datasource, try it out.
Make sure you dont set anything datasource related in the reportviewer on the asp page except for the report path.

Author Comment

ID: 24210257
SNilsson, I now realize that you had more of the type of answer that I was looking for instead of the one offered by "newbial". Respectfully I think Newbiel misunderstood me. So my apologies for not awarding you more points. I need more direction from your answer though. Can you be more specific with regards to binding to the data source? In your instructions i don't have enough information to determine if I should be using SQL Server management studio? Or what tool to make the changes that need to be done.

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

840 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