Reporting Services Report Manager Site Permissions Error After Installation

After a successful installation of SQL Server Reporting Services 2012 on a personal computer such as a laptop, a permissions error is received when accessing the Report Manager site for the first time. The message typically states the following: “User DOMAIN_NAME\userID does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.” This error can occur even though you the user, installer and database administrator have full administrative rights on your device.

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

Troubleshoot :

Depending on your situation there are two methods that will typically resolve this problem. We will start with the easier solution first before moving to the more complicated solution. The goal of both solutions is to get the Site Settings to display in the top right corner as shown below. Site Settings is not displayed in the image above containing the error message.

The first method involves starting Internet Explorer by using the Run as administrator option.

If Site Settings is displayed in the top right corner, click on Site Settings. Click on the Security tab on the left. Next, click on New Role Assignment.

On the New System Role Assignment page, enter your group or user name and then select the System Administrator checkbox. Click on OK.

After clicking on OK, the system role assignments will be shown.

https://lh3.googleusercontent.com/reTkcBnGsOpZkKWS9t1N2nfPmtg_zg1p5_tVWek5EOvJA6KJ6YS10Tjv86bvvIjqxNvamA=s170

Next, click on Home in the top right and then click on Folder Settings.

Click on New Role Assignment. Add your group or user name and then choose the desired roles to be assigned. Click on OK when finished.

If you have made it this far, then the problem should be resolved. Exit from Internet Explorer and reopen Internet Explorer normally without running as administrator and navigate to your local Report Manager site.

https://lh3.googleusercontent.com/B_m118UVvnqMQkU-shn9iwoyxhlKlrrGAWWz2bcZrm9wyE0kKYhkmRHv6UWU9hOLyloi=s170

The second method involves temporarily changing the User Access Control settings.

Change the settings from the default level  to “Never notify” . After clicking OK and rebooting your computer, attempt steps as above. When successfully making these changes, make sure to set the User Access Control settings back to the default level and reboot.


 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.