Getting the permissions right – SSRS in SharePoint Integrated mode


Recently, I was working on securing SSRS reports when running in SharePoint Integrated mode.  Two settings came back to bite me, so I thought I would blog about them.  You probably already know this, but it is one of those things that you scratch your head over until your memory kicks in.  Anyway, I hope this will save someone some time.



  1. Make sure that you “Approve” your data sources.  The error message that is displayed when attempting to run the report is a little misleading.  The message simply states that “the user does not have sufficient permissions to perform this action”.  Anyone who is not a site owner or site collection administrator will get this message.

  2. Make sure that you “Publish a major version” of your report.  Visitors (read-only) will not be able to see the report until a major version is published.  Members (contribute) will be able to see and execute the reports without a major version being published.

 

Comments (3)

  1. steve w says:

    thanks – this error was driving me nuts.  "Approve" the data source, who would’ve thunk it.

    cheers,

  2. Ishwar says:

    Could you explain a little more as to what do you mean by publishing a major version of my report?

  3. WFeaser says:

    SharePoint provides the ability to have minor and major versions of a report.  Typically, minor versions are seen only by admin users (users with full control of the site).  You need to publish a major version (from the report's context menu), so that non-admin users are able to use the report.

Skip to main content