Permissions to Reporting Services
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.
December 4th, 2006 6:10pm

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.
Free Windows Admin Tool Kit Click here and download it now
December 4th, 2006 7:00pm

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.
December 5th, 2006 10:18am

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---
Free Windows Admin Tool Kit Click here and download it now
December 5th, 2006 5:17pm

Are you able to solve this problem?
January 29th, 2008 4:19am

I received the following error when connecting to Sql Server Reporting Services 2005 x86from 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: Run Sql Server Management Studio as Administrator (right click "Run as Administrator") Connect to a Reporting Services server using Windows Authentication. Right click Home, Select Properties, Select Permissions. Click Add Group or User, Type your Username, Click Ok. 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 tobrowse Report Manager(http://localhost/Reports). If not, but you do see the Information Bar complainingthenadd http://localhost/ to Explorer's Trusted Sites Zone. HTH, Steve
Free Windows Admin Tool Kit Click here and download it now
July 10th, 2008 8:42am

Thanks for the info. This was driving me crazy!
July 15th, 2008 10:53pm

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 upthe 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
Free Windows Admin Tool Kit Click here and download it now
August 19th, 2008 10:29pm

Refer to http://support.microsoft.com/kb/934164/en-usif you are seeing this problem while running ona Vista machine. Steps starting 7 might be interesting to you.
August 20th, 2008 10:17am

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
Free Windows Admin Tool Kit Click here and download it now
August 25th, 2008 9:30pm

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
August 25th, 2008 9:30pm

I solved this issue via "Run as Administrator" for both SSMS & IEJeffrey
Free Windows Admin Tool Kit Click here and download it now
March 23rd, 2009 10:09am

Thanks - I tried everything and this is what fixed it for me!
September 16th, 2011 5:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics