Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server Reporting Services (CRM usage, et al.): Role Assignments and Permissions

 

While supporting Microsoft Dynamics for CRM, I was recently quite surprised to have to associate role membership permissions within Reporting Services for users of what I could only assume are extended properties, because up to this point I had thought permissions for reporting services were handled on the database engine side only. However, under OrganisationName_MSCRM and properties you will see the following Role Assignment options.

The link to your own Reporting Services instance should be the following for the above page:
http://REPORTSERVER/Reports/Pages/Folder.aspx?SelectedTabId=PropertiesTab

You might also run into this error, and the above Role configuration should help you fix that:

Reporting Services Error 
________________________________________
The permissions granted to user 'USERNAME' are insufficient for performing this operation. (rsAccessDenied) Get Online Help 
________________________________________
SQL Server Reporting Services

Comments

Posted by Hugo Shebbeare on 31 August 2010

Here's a situation, as described by Marnix Wolf, where this Role Assignment is critical to making Reports work for SCOM: thoughtsonopsmgr.blogspot.com/.../catch-22-securing-acs-reports-and_14.html

Leave a Comment

Please register or log in to leave a comment.