The request failed with HTTP status 401: Unauthorized in Report Services 2008 Sharepoint Integration

Today I tried to integrate Reporting Services and Sharepoint. The setup consisted of three servers:

  • SQL 2008
  • Reporting Services 2008
  • Sharepoint (WSS 3.0) with Reporting Services Addins

When I tried to connect Sharepoint to the Reporting Services Webservice using the Central Administration, I got the following error:

The request failed with HTTP status 401: Unauthorized

However when I manually visited the webservice through the browser @ http://myserver/ReportServer, everything worked fine. So why did the authentication fail for Sharepoint?

My Sharepoint setup uses NTLM authentication only, therefore Reporting Services must be configured for the same authentication type as well. After reading through tons of KB articles and posts, i finally found a solution to the problem:

  1. On the Reporting Services Server, open the config file rsreportserver.config (you find it in the Reporting Services folder)
  2. Look for the Autentication configuration node
  3. Remove the RSWindowsNegotiate setting

The config section in question should now look like this:

    <!-- <RSWindowsNegotiate/> -->

That way, only NTLM is used for authentication. This fixed it for me đŸ™‚


4 Responses to “The request failed with HTTP status 401: Unauthorized in Report Services 2008 Sharepoint Integration”

  1. 1 sharepointfox September 28, 2011 at 12:26 pm

    You are the man!! After playing around with Kerberos and just about every other option out there, I came across your blog. Your solution worked perfectly.. MS, please fix your docs and fix your app!

  2. 2 browse October 9, 2014 at 9:01 am

    you are my hero, man !

  3. 3 Accessoires March 15, 2018 at 4:01 pm

    A fascinating discussion is definitely worth comment.
    I think that you need to publish more about
    this topic, it might not be a taboo matter but
    usually people do not discuss such subjects. To the next!

  1. 1 hail damage chicago Trackback on June 12, 2018 at 4:26 am

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: