I am currently working on Report Builder 2.0 with Reporting Services 2008 and am trying to connect to a SharePoint 2013 site using an XML data source query. SharePoint and Report Builder/Services are on different servers. I enter the correct connection string to the SharePoint lists and have tried to connect through "use current Windows user," manually entering credentials as Windows credentials, and "do not use credentials" but each of these options lead to a 401 unauthorized error. I looked around for solutions and have gotten suggestions of double hop or untrusted connections. Does anyone know what the problem is and how I would go about resolving it?

1 Answer 1


Try going into the SSRS Config utility and set up an execution account, then grant that execution account read access to the site you're trying to get to.

  • I entered my SharePoint admin account as the execution account but I am still receiving the same error. Commented Oct 9, 2013 at 20:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.