Sunday 10 April 2011

SQL 2008 Reporting Services Permissions Issue

Issue

In SQL Server 2008 Managment Studio, when attempting to open Security > Roles > {any of the security groups} I get the following error:

Cannot show requested dialog.
Additional Information:
The permissions granted to user 'domain\login' are insufficient for performing this operation (rsAccessDenied)(Report Services SOAP Proxy Source)
The permissions granted to user 'domain\login' are insufficient for performing this operation (rsAccessDenied)(ReportingServicesLibrary)

I am a local administrator on the server.

Fix

When starting SQL Server 2008 Management Studio, choose 'Run As Administrator'. 

DOH!

No comments:

Post a Comment