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. Anonymous says:

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


  2. Anonymous 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.

Comments are closed.

Skip to main content