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