May 23, 2010 at 4:23 pm
Hi everyone,
I'm receiving the following error while trying to access ReportServer from IIS v5 or on Browser. I made sure that the both IUSR_MyComputerName and ASPNET user accounts are in Administrators group.
'The permissions granted to user 'MyComputerName\IUSR_MyComputerName' are insufficient for performing this operation. (rsAccessDenied) Get Online Help' .
I even created these logins in SQL Server and gave server admin and sys admin rights. But still receivint the error.
Can someone tell me whats causing this issue?
Thanks in advance!
May 24, 2010 at 2:38 am
have you tried logging in as an administrator browse to http://servername/reports then in site setting >Configure Site-Wide Security > system role assignments >add new role assignment
put in your username.
May 25, 2010 at 3:17 pm
Yes i've logged in as an administrator. Can you explain me "site setting >Configure Site-Wide Security > system role assignments >add new role assignment - put in your username" in detail. Do you mean the settings in the IIS?
Thanks!
May 26, 2010 at 1:36 am
You should have two web sites created
http://servername/reports This is where you set access rights.
http://servername/reportserver Gives an explorer view.
You may need to use http://localhost/reports
If this wont work check the report setting in Start>Microsoft SQL Server 2005>Configuration Tolls>Reporting Services Manager
Also in IIS I have switched off anonymous access and use windows Auth
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply