Skip to main content

Posts

Showing posts from October, 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 gr