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.

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.

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

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