SQL Server Reporting Services Report Manager Site Permissions Error After Installation

By:   |   Comments (12)   |   Related: > 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.

UAC Disabled
Next Steps
  • Read through our Reporting Services Tutorial.
  • Read through our Report Builder Tutorial.


  • sql server categories

    sql server webinars

    subscribe to mssqltips

    sql server tutorials

    sql server white papers

    next tip



    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.

    This author pledges the content of this article is based on professional experience and not AI generated.

    View all my tips



    Comments For This Article




    Thursday, March 28, 2019 - 1:14:45 PM - Elena Garcia Back To Top (79414)

     Sorted my issue, I can now access reporting systems


    Tuesday, August 2, 2016 - 1:14:59 PM - Holly Back To Top (43032)

    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 3, 2016 - 9:16:10 AM - Vikram Back To Top (40581)

    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 (39144)

    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 (38963)

    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 (37223)

    THis is Greate Post To Help for new devlopers


    Saturday, April 4, 2015 - 11:03:15 AM - Franklin Raja Back To Top (36827)

    Thanks for the tips. This resolved my issue.


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

    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 (35108)

     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 8, 2014 - 1:21:43 AM - Noopur Back To Top (34429)

    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 (32360)

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


    Friday, June 6, 2014 - 1:12:36 PM - cheralathan ilangovan Back To Top (32123)

     

     

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















    get free sql tips
    agree to terms