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 ‘TESTDOMuser’ 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 “TESTDOMuser” 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 thoughts on “SSRS 2008 Domain User Issue”
Thank you so much! This fixed my MSSRS issue!!!
No problem! Glad that it was helpful.
Many Many thanks 🙂
Thank u so much..
hi this issue resolved …now its giving me rsAccessDenied error plz help i am stuck badly
Thank you!!!!!
Thank you so much .. it worked for 2012 as well.
Worked like a charm even in 2013! 🙂 Thank you for taking the time to post this!
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
Precise,concise and useful, that is how all posts should be. Thank you so much
Thank you so much.. This fixed my issue 🙂
Thanks a Lot .I has worked
very useful to us,thanks a lot….
Worked like a charm!. Thanks for taking your time to post this.