GotKnowHow.com

How to fix Reporting Services permissions are insufficient for performing operation (rsAccessDenied)

Learn how to configure and access SQL Server Reporting Services reports when you get The permissions granted to user 'domain\username' are insufficient for performing this operation. (rsAccessDenied)
by


When using the Report Server on your local computer, you can use the Local Service, Local System or Network Service built-in account. All three accounts should give you access to http://localhost/reports when configured correctly.
Here's the default Report Server Web Service Virtual Directory. You shouldn't need to make changes to it, in order to access http://localhost/reports
You will need to add the localhost Host Header URL to the Report Manager Site Identification, if you don't see it listed in the Report Manager URL page, otherwise you will get an error when trying to access: http://localhost/reports
Add localhost Host Header Name to the Report Manager URL.
Click the SQL Server Reporting Services Properties tab from the Home page, to add your computers domain\username account to get access to the reports server.
Add your computers 'domain\username' to a New Role Assignment in SQL Server Reporting Services and select all the appropiate roles for the group or user.

If you are getting the following error while trying to access or deploy a SQL Services Reporting Services (ssrs) report server on your localhost: 

The permissions granted to user 'domain\username' are insufficient for performing this operation. (rsAccessDenied)

 

Here's what to do: 

  1. Make sure you have access configured to the URL http://localhost/reports using the SQL Reporting Services Configuration. To do this:
    1. Open Reporting Services Configuration Manager -> then connect to the report server instance  -> then click on Report Manager URL.
    2. In the Report Manager URL page, click the Advanced button -> then in the Multiple Identities for Report Manager, click Add.
    3. In the Add a Report Manager HTTP URL popup box, select Host Header and type in: localhost
    4. Click OK to save your changes.
  2. Now start/ run Internet Explorer using Run as Administator...  
    • NOTE: If you don't see the 'Site Settings' link in the top left corner while at http://localhost/reports it is probably because you aren't running IE as an Administator or you haven't assigned your computers 'domain\username' to the reporting services roles, see how to do this in the next few steps.
  3. Then go to: http://localhost/reports   (you may have to login with your Computer's username and password)
  4. You should now be directed to the Home page of SQL Server Reporting Services here: http://localhost/Reports/Pages/Folder.aspx
  5. From the Home page, click the Properties tab, then click New Role Assignment
  6. In the Group or user name textbox, add the 'domain\username' which was in the error message (in my case, I added: DOUGDELL3-PC\DOUGDELL3 for the 'domain\username', in your case you can find the domain\username for your computer in the rsAccessDenied error message).
  7. Now check all the checkboxes; Browser, Content Manager, My Reports, Publisher, Report Builder, and then click OK.
  8. You're domain\username should now be assigned to the Roles that will give you access to deploy your reports to the Report Server.  If you're using Visual Studio or SQL Server Business Intelligence Development Studio to deploy your reports to your local reports server, you should now be able to.
  9. Hopefully, that helps you solve your Reports Server rsAccessDenied error message...

Just to let you know this tutorial was done on a Windows 7 computer with SQL Server Reporting Services 2008.

 


0
17

17 Comments

anonymous by Francis on 8/15/2010
Great, this finally fixed my problem after a few hours of searching. Pretty incredible that when you install SSRS 2008 from scratch, one has to do all of this when I installed SQL 2008 with an admin account.
Doug by Doug on 8/15/2010
Francis,

I agree, setting up SSRS could and should be much easier... I can't tell you how much time I've spent just trying to get Reporting Services to run correctly. It's nice once it's working for you, but getting it setup properly is a huge pain.
anonymous by Freese on 8/25/2010
Thanks. Fixed my problem.
anonymous by james on 10/13/2010
i don't see the properties part in the report manager page. it's all blank underneath home. how would you make it show up? i just installed it in windows 7 with SQL Server 2008
anonymous by Anonymous on 11/15/2010
@james

I think you are using Firefox.or any browser which is not related with Microsoft. Use IE it will be solved..I think it will help you..Thank you
anonymous by Mr Mostard on 1/4/2011
@james
In my case the button is called "Folder Settings" instead of "Properties" (SQL 2008R2).

@doug
Thanks, this one saves me a couple of hours! :)
anonymous by jack on 1/27/2011
great solution..now I can deploy my report to Report server.
thanks
anonymous by frinkfree on 2/25/2011
Awesome. Your detailed steps solved the problem. thanks
anonymous by Madhu on 6/10/2011
Really Great User Guide..!!

Thanks for your work done man..
anonymous by Jacek on 6/21/2011
Thanks. Nice, simply, precise solving.
anonymous by Kathy on 7/21/2011
Thanks a lot. It fixed the problem.
anonymous by Lenrog on 7/27/2011
Hi will this fix work if my 2008 Report server is in SharePoint Integrated mode?
anonymous by Andy on 8/29/2011
Thanks Doug..
anonymous by Sudheshna Koroth on 9/2/2011
Thank you , it worked
anonymous by Moazzam on 9/20/2011
I am using SQL treporting under sharepoint hence it is in sharepoint 2010 integrated mode, when i go to the report URL http://localhost/Reports/Pages/Folder.aspx , i get

This operation is not supported on a report server that is configured to run in SharePoint integrated mode. (rsOperationNotSupportedSharePointMode) Get Online Help

Please guide
anonymous by Mortaza 3 days ago
Thank you, this helped me a lot!
anonymous by Mansvi 2 days ago
It's not working,giving the same error again.
I am working on Windows XP computer with SQL Server Reporting Services 2005.
Please help.
Thanks In Advance

Add your comment

by Anonymous - Already have an account? Login now!
Your Name:  

Comment:  
Enter the text you see in the image below
What do you see?
Can't read the image? View a new one.
Your comment will appear after being approved.

Ask a Question

140 characters left

Recent Articles

Follow Us...