SQL Report Builder 2.0 Error:  Request failed with HTTP status 401: Unauthorized

Posted on 2009-04-24
Last Modified: 2012-05-06
I'm trying to get report bulding up and running, and I can create and run a report on the report server itself, but when I try to run the report from Report Builder 2.0 on a user's machine I get "The request failed with HTTP status 401: Unauthorized."  Here are some notes:
1. I can choose a published Datasource from the report server on the user machine so I must have at least some permissions.  
2.  The user in question even has domain admin rights.
3.  Trying to go to the reportserver site http://servername/reportserver on the user's machine gives me an NT authentication box that does not accept any credentials, even of the domain admin account.  I can access both the reportserver and reportmanager site fine from the report server itself.
4.  Even logging in as the actual domain admin from a different PC gives me the same errors.  

From those I am deducing that somewhere permissions are set for only the local machine, BUT I have no idea where to begin on finding out exactly which permissions are wrong.  All the file-level permissions look good, and I don't see any Permissions settings for the Report server application pools.  I've spent two days trying to figure this out and it's probably something simple.  I am using SQL 2008 Enterprise with Reportings Services and Report Builder 2.0.
Question by:dgooge

    Accepted Solution

    Finally figured it out.  This problem was due to some weird effect Microsoft Data Protection Manager had, it actually changed security settings in the IIS Metabase, specifically AccessFlags.  Have no idea why, but here is the resource with the solution:


    Expert Comment

    I was able to solve this same issue by using the host name for the report server instead of the IP address.  I did not have Data Protection Manager installed but had the exact same issue.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    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…
    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…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    737 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

    23 Experts available now in Live!

    Get 1:1 Help Now