Watchdoc for Reporting Services (WRS) - Reporting Services Error - Access denied

August 2018

Context

In the case you can't access the WRS® reports pages and the following message is displaying: Reporting Services Error: Access denied

Cause(s)

It can be due to a rights configuration problem. It's then necessary to check the rights of the 3 following tools and to modify them if neccessary:

• Internet Explorer® browser rights;

• Content Manager rights;

• System Administrator rights.

Resolution

Manage the IE Browser rights

By default, MS Reporting Services® only gives access to the local administrator profile. To add rights to a domain user:

1. as a local administrator, access the server on which is installed Reporting Services;

2. in this server, run Internet Explorer;

3. in Internet Explorer, access the Security tab: Tools > Internet options > Security Tab;

4. Select Trusted sites, then click on the Sites button:
   
   
   

    

5. unthick the Require server verification box;

6. add http://localhost to the websites zone list;

7. click on the Add button:
   
   

    

8. When the http://localhost address is displayed in the Web Sites field, click on the Close button.

 

Manage the Reports manager rights (MS SQL Reporting Services)

To check the reports manager rights:

1. from the server on which MS SQL® is installed, run the Internet Explorer® browser as an administrator;

2. with Internet Explorer ran as a local administrator, access the reports manager URL: http://localhost/Reports_WATCHDOC;

3. click on Folder Settings:
   
   
   
   

4. in the Security section, click on New Role Assignment:
   

    

5. in the User name field, enter the name (domain\login) of the user entitled to manage the content;
   

6. tick the Content Manager role, then validate by clicking on the OK button;
   
   

 

System Administrator rights

1. Still from the Report Manager, click on Site Settings:
   

2. On the Security tab, click New Role Assignment;
   
   

    

3. In the User or Group Name field, enter the profile (in the form: domain\login) of the user who can manage the content;
   
   

    

4. Check the System Administrator role and click OK:
   

    

5. Close the browser and Internet Explorer, then restart it without running it as an administrator