SSRS 2008: The request failed with HTTP Status 401: Unauthorized

Posted on 2012-08-22
Last Modified: 2012-09-17

We have SSRS 2008 running on our production SQL Server, where I have deployed a data source and report. We are trying to display that report from our application using the “ReportViewer” control. The report only displays if I provide the Windows Server's Administrative Credentials to the report viewer control using the following line of code


If I do not provide these credentials OR provide any of the credentials used to access the database, I get an exception that says “The request failed with HTTP status 401: Unauthorized”.

Since I have to provide Windows Administrative credentials that we use to logon to the server, I do not feel it is a secure way of generating reports.

I tried adding the following line to web.config “<identity impersonate=”true”>”, but that did not help.

I also added a new user with the type "Browser" role, but I do not know how to connect with this new user as I do not see a Windows account with the same user name.

My questions are as follows:

1) Is there a way to generate the reports on our Reporting Server and have them display on a aspx page without providing these Credentials?

2) Since reporting service runs on port 80, do I need to create a Firewall rule for that port.

3) Do I need to create a new Windows user without Admin privilidges with the same Username as the new user I created on SSRS?
Question by:rpotash
    1 Comment
    LVL 1

    Accepted Solution

    you should have to configure your reportting service with built in admin user only

    2)port 80 enough,no need for firewall rule

    3)after that you give only browser access to your user with whom you call ssrss report in .net application

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
    This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video discusses moving either the default database or any database to a new volume.

    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

    11 Experts available now in Live!

    Get 1:1 Help Now