Tuesday, March 20, 2012

Permissions Issue Logging into Mgt Studio

I am unable to log into SSRS from Mgt Studio and receive a permissions error when I go to http://ServerName/reportserver in IE. When loging into Mgt Studio I've entered the following for the server name:

ServerName
ServerName\Insance
http://ServerName/reportserver

The first two methods return an error "server cannot be found". The third allows me to login but when I click on "Home" I receive:

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
ADDITIONAL INFORMATION:

The permissions granted to user 'mydomain\myAccount' are insufficient for performing this operation. (rsAccessDenied) (Report Services SOAP Proxy Source)
The permissions granted to user 'mydomain\myAccount' are insufficient for performing this operation. (rsAccessDenied) (ReportingServicesLibrary)

******************************************
I am a member of the dcom and power users group. Does anyone know what is causing this and how to resolve?

thanks in advance,
ScottSounds like you haven't set the correct permissions ;)
Goto http://localhost/reports as a local-administrator then on root -> properties and add a new role for mydomain\myAccount..
For testing you could add "Everyone" as a content-manager and then reduce the rights until they fit for your case..

No comments:

Post a Comment