rsAccessDenied - SQL Server 2012 Reporting Services

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.

Answers


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.


Need Your Help

How do you handle live video streaming in Flash AS3?

flash actionscript-3 sockets video-streaming

I've been dabbling with socket servers in Java and now I'm ready to get my feet wet with an idea I had.

How to recover data from a table, and store that into list?

java mysql hibernate orm data-recovery

How can I get ALL the data from a table of my DB (mySQL) using hibernate, and store the output into List of Objects?