SSRS The permissions are insufficient for performing this operation

0
votes

I am new to SSRS and deployed my first report with it. When deploying the report, I added access to the site for the user group DOMAIN\user-group with the "System User' role under Site Settings > Security. I also added the group to the home folder with the browser role and ensured all folders and items inherit parent settings. The report is running with a service account with SA permissions to the DB it is reading from.

When I run the report locally or remotely as myself then I am able to run it, however whenever a member of the domain group tries to run it they get the below error message:

An error has occurred during report processing. (rsProcessingAborted)

The permissions granted to user 'DOMAIN\user' are insufficient for performing this operation. (rsAccessDenied)

2
reporting-servicesssrs-2012
Make sure that they/you have access to the Data Sets as well if you have any that are shared. – Kidiskidvogingogin
Thank you so much, that was so frustrating. There was one data set that was not inheriting. – Andrew O'Brien
I ran into a similar problem myself and finally figured it out by looking at the ExecutionLog views in the SSRS DB. – Kidiskidvogingogin

2 Answers

0
votes

Thanks @Kidiskidvogingogin. One data set was not inheriting permissions.

0
votes

Even though the problem above got resolved, I am adding my answer just in case someone else would come across this issue in the future.

Had the same error message, but after many trials of playing with SQL securities, it appeared as if the SSRS folders didn't have the security level required. Added an Admin security level, and the problem was resolved.