I am using the SharePoint report services integration.
I deployed a report to a document library, but when I try to view the report (form SP), I receive this error:

login failed for user 'nt authority anonymous logon' sharepoint

If I open the report (with the same user) from the report builder client, it is working fine.
What is it wrong?


1 Answer 1


You need to set the Credentials of the Report Data Source please refer to http://msdn.microsoft.com/en-us/library/dn198312.aspx for details on this. We use a single database user account (the 'ReportUser') and stored credentials. This has been inherited from our stand alone configuration and works fine in SharePoint. Report Builder is running fine because it's using your windows credentials. There are a few configuration issues so read the Microsoft page carefully. Particularly if your report server is on a different computer to your SharePoint server.

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.