Tuesday, October 23, 2012

The permissions granted to user 'mydomain\myAccount' are insufficient for performing this operation - rsAccessDenied


Just a short post re the above SQL Reporting Services 2008 R2 error when running in Integrated Mode.

I found that PWA Administrator users could run RS Reports without issue, but any Project Server users accessing the reports were greeted with rsAccessDenied - The permissions granted to user 'mydomain\myAccount' are insufficient for performing this operation
I checked my RDL details and confirmed that:

- Report published to ProjectBICenter\Reporting%20Services doclib
- DC published to ProjectBICenter\Data%20Connections%20for%20Performancepoint

So my users should have permissions as these libraries inherit from the BI Center.
After experimenting with these permissions for a little while, it turns out the SP permission required was "Contribute" permission.  Now that's a new one!

So, I've:
- Created a new SP group and granted Collaborate on the site/sublibraries
- allocated my ProjectReportAuthors and Readers groups (AD) to this SP group.

And it works...ta da!