Showing posts with label reportserver. Show all posts
Showing posts with label reportserver. Show all posts

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

Monday, February 20, 2012

Permission Denied Javascript errors

I have a report I've been running for several months using a URL like the one
below:
http://server/ReportServer?/folder/report&rs:Command=Render
I updated the report today and now I get 2 "Permission Denied" javascript
errors when the page loads. One is in function OnLoadToolbar calling
SetShowHideParameters and the other is in function LoadToolbarFrame on an if
statement (if (frames["oTbDMRepFram"0.location... The report works fine when
I go to the report manager in my browser and works fine in VS.NET. Any help
is appreciated.I found a workaround. I had unchecked "Show Friendly HTTP Errors" in my
browser. When I re-activated it, the report runs fine.
"jweesies" wrote:
> I have a report I've been running for several months using a URL like the one
> below:
> http://server/ReportServer?/folder/report&rs:Command=Render
> I updated the report today and now I get 2 "Permission Denied" javascript
> errors when the page loads. One is in function OnLoadToolbar calling
> SetShowHideParameters and the other is in function LoadToolbarFrame on an if
> statement (if (frames["oTbDMRepFram"0.location... The report works fine when
> I go to the report manager in my browser and works fine in VS.NET. Any help
> is appreciated.
>