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.