Advertisements
Home > Business Intelligence, SQL Server 2008 R2, SSRS > User Account Control (UAC) and SSRS

User Account Control (UAC) and SSRS

In SQL Server 2008 R2 Reporting Services people are facing error as “User ‘DomainName\UserName’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed”. I have seen people struggling with this Issue. Here is more light on how to fix this & get your SQL Reporting Services Report Server URL working.

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

  1. Configure the report server for local administration. To access the report server and Report Manager locally, follow these steps:
  2. Start Windows Internet Explorer.
  3. On the Tools menu, click Internet Options.
  4. Click Security.
  5. Click Trusted Sites.
  6. Click Sites.
  7. 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.
  8. Click Add.
  9. Repeat step 7f and step 7g to add the http://localhost URL, and then click Close.
  10. Note This step enables you to start Internet Explorer and open either the localhost or the network computer name of the server for both the Report Server application and the Report Manager application.
  11. Create role assignments that explicitly grant you access together with full permissions. To do this, follow these steps:
  12. 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.
  13. Open Report Manager. By default, the Report Manager URL is http://ServerName/reports.
  14. If you use SQL Server Express with Advanced Services SP2, the Report Manager URL is http://ServerName/reports$sqlexpress. If you use a named instance of Reporting Services, the Report Manager URL is http://ServerName/reports$InstanceName</var>
  15. In the Home dialog box, click Properties.
  16. Click New Role Assignment.
  17. Type a Windows user account name by using the following format:
  18. Domain\User
  19. Click to select the Content Manager check box.
  20. Click OK.
  21. In the Home dialog box, click Site Settings.
  22. Click Configure site-wide security.
  23. Click New Role Assignment.
  24. Type a Windows user account by using the following format:
  25. Domain\User
  26. Click System Administrator.
  27. Click OK.
  28. Close Report Manager.
  29. Use Internet Explorer without the Run as administrator option to reopen Report Manager.

Also, see the following thread (look for post that was marked as answer)

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/e8da121a-c0ac-4d0b-8774-abd5128d88fe

Sandip Shinde

Advertisements
  1. Ashish Tiwari
    May 22, 2012 at 12:34 pm

    Great piece of information. It saved lot of time for me.
    Thanks for posting.

    Ashish Tiwari

  2. Kumar
    February 1, 2013 at 7:46 pm

    We have a report which i would like to access through URL with out any access credentials.

    I would like any one from any where just type the url in the browser and they just view the report with out entering any user name or password.

    Could you please tell me how could i achieve this ?

    Please help me

    Environment:
    1) Windows 2008 server R2 with Active Directory Services
    2) Microsfort Sql Server 2008 r2 Enetrprise version

    The above solution did not work in the above senario. Could you please let me know any other alternative

  3. Frank Canapa
    October 28, 2016 at 9:47 pm

    After following these steps the user still continued to get the UAC error message. The only resolution that I could find was to add the user to the local(SSRS) admin group.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: