Permissions to Reporting Services

Question

I have been looking at forums trying to resolve my problem and now my brain hurts.  I really need help with this and no one seems to have a definitive answer.

When launch Reporting Services, the page is blank and the settings options are missing.  Even though I am logged on to the server with a local admin account.

I have tried taking off annonymous access but when I do this I just get the page can not be displayed.

Also when connecting to ReportingServices through the Management Studio I get the following message:

 

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

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

Any help on this would be much appreciated.  I really need to get this sorted out.

Thanks.

Answer 1

goto your inetmgr from start -  run

 

under your virtual directory - directory settings uncheck anonymous login and just check the integrate windows authentication.

 

it should work, just make sure you have given permissions for the reportserver folder for aspnet and also iusr_machinename.

 

 

Answer 2

I have done what you suggested but it has not made any difference.  I would be really greatful if someone had the answer to this.

Answer 3

 

Hi,

To make sure that this is possible you will have to:

-Setup the authentication mode for Reports and Reportserver virtual directories to WIndows authentication and disable the anonymous access.
-Make sure that Internet Explorer or your browser of choice is able to submit the Windows credentials.
-Make sure that the account which you are using for connecting is granted the appropiate rights in Report Server. If you are not sure, logon on the remote server and open the reports interface with a local adminstrator account. Look in the Site Server security settings if the account you first wanted to connect with is in the appropiate group. Sometimes, due to security reasons, domain admins are excluded from the local administrator group, leading to not being able to connect to the server or any services which are normally configured for local Administrator group access.

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Answer 4

 

Are you able to solve this problem?

Answer 5

I received the following error when connecting to Sql Server Reporting Services 2005 x86 from Sql Management Studio on Vista x64.

 

"The permissions granted to user 'Domain\Username' are insufficient for performing this operation. (rsAccessDenied) (Report Services SOAP Proxy Source)"

 

The solution that worked for me was:

1. Run Sql Server Management Studio as Administrator (right click "Run as Administrator")
2. Connect to a Reporting Services server using Windows Authentication.
3. Right click Home, Select Properties, Select Permissions.
4. Click Add Group or User, Type your Username, Click Ok.
5. Check the box for Content Manager, Click Ok.

Now you can access Reporting Services via Sql Server Management Console without running as administrator.

 

You should also have permissions to browse Report Manager (http://localhost/Reports).  If not, but you do see the Information Bar complaining then add http://localhost/ to Explorer's Trusted Sites Zone.

 

HTH,

Steve

 

Answer 6

Thanks for the info. This was driving me crazy!

Answer 7

 

Hi,

 

I have tried the above, but I can't / don't have access to the Administrator account on this machine, though the account I'm logged into the machine does have Admin priveleges.

 

When I bring up the Report Manager webpage, all I see is 'Home' with nothing underneath it.

 

When I connect via Management Studio to the Reporting Services and click on 'Home', I get the rsAccessDenied (Report Services SOAP Proxy Source) error.

In NTFS, I've granted the ASPNET, IUSR_<machinename> users Full Control on the ReportManager folder.

 

Does anyone have any ideas what's going on?

 

Thanks,

Chris

Answer 8

Refer to http://support.microsoft.com/kb/934164/en-us if you are seeing this problem while running on a Vista machine. Steps starting 7 might be interesting to you.

 

 

Answer 9

I recreated the Reports and ReportServer virtual directories using the SSRS admin console, and this fixed the issue. Not sure what it was, but there were so many changes to the VD's that this was the easiest way.

 

Thanks for your help!

-Chris

 

Answer 10

I recreated the Reports and ReportServer virtual directories using the SSRS admin console, and this fixed the issue. Not sure what it was, but there were so many changes to the VD's that this was the easiest way.

 

Thanks for your help!

-Chris

 

Answer 11

I solved this issue via "Run as Administrator" for both SSMS & IE

---

Jeffrey