SSRS Report Manager Site Error

If you come across this error when opening the Remote Manager site, follow the steps specified below to provide the user with required permissions.

Error text: User ‘DOMAIN\user’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

UAC is causing the error, from http://support.microsoft.com/kb/934164.

Configure the report server for local administration. To access the report server and Report Manager locally, follow these steps:

1. Start Windows Internet Explorer.
2. On the Tools menu, click Internet Options.
3. Click Security.
4. Click Trusted Sites.
5. Click Sites.
6. Under Add this Web site to the zone, type http://ServerName. If you are not using HTTPS for the default site, click to clear the Require server certification (https:) for all sites in this zone check box.
7. Click Add.

 

Create role assignments that explicitly grant you access together with full permissions. To do this, follow these steps:

1. Start Internet Explorer together with the Run as administrator option. To do this, click Start, click All Programs, right-click Internet Explorer, and then click Run as administrator.
2. Open Report Manager site. By default, the Report Manager URL is http://ServerName/reports.
3. In the Home dialog box, click Folder Settings.



4. Click New Role Assignment.

1. Type a Windows user account name by using the following format:
   Domain\User
2. Click to select the Content Manager check box.
3. Click OK.



1. In the Home dialog box, click Site Settings.
2. Click Security tab
3. Click New Role Assignment.
4. Type a Windows user account by using the following format:
   Domain\User
5. Click System Administrator.
6. Click OK.



1. Close Report Manager.
2. Use Internet Explorer without the Run as administrator option to reopen Report Manager and you should no longer get an error.