Tuesday, September 21, 2010

SSRS 2008 Domain User Issue

Scenario: I have a new SQL Server Reporting Services 2008 R2 x64 instance that works if you are the local administrator. Once I switch to another user who is an implied administrator via an AD group I get the following error when attempting to access SSRS in a browser:

"User 'TESTDOM\user' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed."

The user is a member of the domain admins group which is obviously a member of the local admins. Also if I right click on IE8 and say "Run As Administrator" it works. The quick fix is to disable the UAC. If you don't want to do that then just do the below:

1. Launch IE8 using "Run As Administrator" and in SSRS (http://servername/Reports) click on Site Settings. In Site Settings navigate to "Security" and add your user "TESTDOM\user" as a System Administrator.

2. Click on "Home" and then "Folder Settings". Now add your account again this time assigning yourself all the roles (Browser, Content Manager, My Reports, Publisher, Report Builder).

3. Close Administrative IE session and open a normal IE8 window and your SSRS should work.

14 comments:

  1. Thank you so much! This fixed my MSSRS issue!!!

    ReplyDelete
  2. No problem! Glad that it was helpful.

    ReplyDelete
  3. hi this issue resolved ...now its giving me rsAccessDenied error plz help i am stuck badly

    ReplyDelete
  4. Thank you so much .. it worked for 2012 as well.

    ReplyDelete
  5. Hello,
    I don't have ""Site Settings.

    1. Launch IE8 using "Run As Administrator" and in SSRS (http://servername/Reports) click on Site Settings.

    Any suggestions please?

    I appreciate your help.

    Thanks,
    Manar

    ReplyDelete
  6. Worked like a charm even in 2013! :) Thank you for taking the time to post this!

    ReplyDelete
  7. Precise,concise and useful, that is how all posts should be. Thank you so much

    ReplyDelete
  8. Worked like a charm!. Thanks for taking your time to post this.

    ReplyDelete
  9. very useful to us,thanks a lot....

    ReplyDelete
  10. Thank you so much.. This fixed my issue :)

    ReplyDelete