Share via

Getting the permissions right - SSRS in SharePoint Integrated mode

  • Article

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

  • Anonymous
    February 23, 2010
    The comment has been removed
  • Anonymous
    January 16, 2012
    Could you explain a little more as to what do you mean by publishing a major version of my report?
  • Anonymous
    January 16, 2012
    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.