Learn more about SQL Server tools

 

Tutorials          DBA          Dev          BI          Career          Categories          Events          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Events

DBA    Dev    BI    Categories

 

SQL Server Reporting Services Report Manager Site Permissions Error After Installation


By:   |   Read Comments (11)   |   Related Tips: > Reporting Services Security

Problem

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.

SQL Server Reporting Services Permissions Error After Installation
Solution

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 goal of both solutions is to get the Site Settings to display in the top right corner as shown below

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

MSSQLTips.com Sample Image

2. If Site Settings is not displayed, please skip to step 8. 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.

If Site Settings is displayed in the top right corner, click on Site Settings

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

select the System Administrator checkbox

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

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

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

click on Folder Settings

6. 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.

Click on New Role Assignment

7. 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.

If you have made it this far, then the problem should be resolved

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

The second method involves temporarily changing the User Access Control settings

9. Change the settings from the default level as shown above to "Never notify" shown below. After clicking OK and rebooting your computer, attempt steps 1 through 7 above. When successfully making these changes, make sure to set the User Access Control settings back to the default level and reboot.

Change the settings from the default level as shown above to "Never notify"
Next Steps
  • Read through our Reporting Services Tutorial.
  • Read through our Report Builder Tutorial.


  • Last Update:






    About the author
    MSSQLTips author Dallas Snider Dr. Dallas Snider is an Assistant Professor in the Computer Science Department at the University of West Florida and has 18+ years of SQL experience.

    View all my tips


     









    Post a comment or let the author know this tip helped.

    All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

    *Name    *Email    Notify for updates 


    Get free SQL tips:

    *Enter Code refresh code     



    Tuesday, August 02, 2016 - 1:14:59 PM - Holly Back To Top

    All these years later and this post saved me.   Thanks so much for your helpful post and screen shots, I was at my wit's end.

     

     


    Wednesday, February 03, 2016 - 9:16:10 AM - Vikram Back To Top

    Thanks. Great Post!

    I am having completely opposite situation.

    After installing SSRS 2014, I noticed that all users on the domain have complete access to the reports manager site.

    I have not setup any security/access permissions on the Reports Manager site. Only BUILTIN\Administrator have full access (which is default configuration).

    But every domain user can still browse the Reports Manager site without any restrictions.

    How can I prevent this? I want only the users who have been assigned permissions to be able to access the Reports Manager and contents.

     

    I changed the rsreportserver.config file and added RSWindowsBasic as the authentication type. So now I at least get a login prompt. But once you enter your domain username/password, you can access full Reports Manager site.

    Please help.

     

    Thanks.

     

     


    Wednesday, November 25, 2015 - 6:20:35 PM - Raj Back To Top

    Thank You, the above post was awesome and resolved the access permission problem


    Monday, October 26, 2015 - 6:42:09 AM - Domenico Back To Top

    Many many thanks... your post saved me!! The only clear and functional solution.


    Tuesday, May 19, 2015 - 8:27:24 AM - mayank Back To Top

    THis is Greate Post To Help for new devlopers


    Saturday, April 04, 2015 - 11:03:15 AM - Franklin Raja Back To Top

    Thanks for the tips. This resolved my issue.


    Thursday, December 25, 2014 - 1:26:19 AM - H.michael Back To Top

    This a great post and helped me to solve my problem. Thank you for your help sir.

     


    Wednesday, October 29, 2014 - 8:48:45 AM - Iuri Raposo Back To Top

     I have a question... after follow the procedure described in the post , can I enable UAC again and I can still acess the reporting services?


    Monday, September 08, 2014 - 1:21:43 AM - Noopur Back To Top

    Very Useful link. I searched on web for this problem but got the solution by disabling UAC for a while only which is not mentioned exactly on other links.


    Monday, June 23, 2014 - 5:59:31 PM - vkp Back To Top

    Great information in a simple methods....Really it helped me a lot. Thank you so much for the great post!!


    Friday, June 06, 2014 - 1:12:36 PM - cheralathan ilangovan Back To Top

     

     

    excellent Post .. nearly three hours of breaking my head .. you solved my issue by disabling the UAC 


    Learn more about SQL Server tools