How to bypass the Reporting Services username & password prompt.

Posted on 2009-04-15
Last Modified: 2012-08-13
I have a C#/ web application that uses a report viewer control to
display a  Reporting Services report. When the 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
    LVL 4

    Accepted Solution

    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.
    LVL 8

    Assisted Solution

    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.
    LVL 2

    Author Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
    Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now