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