Wednesday, September 2, 2015

rsAccessedDenied - SQL Server Reporting Services Error

This error occurs when users do not have proper permissions to the report server.


To fix it, proper role assignment has to be done by local administrators.
.   
.       1.  Start Internet Explorer using "Run as Administrator"
  1. Open http://localhost/reports
  2. Go to Folder Settings (SQL Server 2012 is used 
      4.  Click on New Role Assignment


      5.   Add DOMAIN/USERNAME or DOMAIN/USERGROUP and assign appropriate roles



Re-check the url http://localhost/reports with the original user.