rsAccessDenied - SQL Server 2012 Reporting Services

1
votes

I have installed SQL Server 2012 on my Windows 10 computer. When I try to access Reporting Services via the Browser such as Chrome or Firefox, It prompts me for username/password (In which I do enter) but then it gives me an error

(Reporting Services Error: The permissions granted to user 'ComputerName\User' are insufficient for performing this operation. (rsAccessDenied)).

I have tried many solutions such as Internet Options and SQL server management studio. I have spent most of my time trying to figure this out but have given up hope.

1
sqlreporting-servicessql-server-2012
What URL are you using to attempt to access reporting services? Are you attempting to access reporting services from a different machine? Have you grant permissions reporting services for the account you are trying to access with? – SQLBobScot
@BobF I am using http://<computer-name>/<reports>, I am using it locally and I set up SQL server 2012. When it asks me for Username and Password my input is valid but it still gives me the rsAccessDenied error – Prokaryote
Have you read over this posting - stackoverflow.com/questions/3389040/… ? This article is a excellent guide to setting up SSRS for the first time - thecodeattic.wordpress.com/category/ssrs – SQLBobScot

1 Answers

2
votes

Assuming you are trying to access Report Manager application (and not the Report Server) try this:

  • Run Internet Explorer as Administrator
  • Browse to Report Manager URL e.g. http://localhost/reports
  • You should see the Report Manager "home" page
  • Go to the Security settings for the home page and explicitly add your user account with the "Content Manager" role

You should now be able to browse to the home page with IE or Firefox. Note that Chrome is not a supported browser for SSRS 2012.