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.
Thank you so much! This fixed my MSSRS issue!!!
ReplyDeleteNo problem! Glad that it was helpful.
ReplyDeleteMany Many thanks :)
ReplyDeletehi this issue resolved ...now its giving me rsAccessDenied error plz help i am stuck badly
ReplyDeleteThank u so much..
ReplyDeleteThank you!!!!!
ReplyDeleteThank you so much .. it worked for 2012 as well.
ReplyDeleteHello,
ReplyDeleteI 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
Worked like a charm even in 2013! :) Thank you for taking the time to post this!
ReplyDeletePrecise,concise and useful, that is how all posts should be. Thank you so much
ReplyDeleteWorked like a charm!. Thanks for taking your time to post this.
ReplyDeletevery useful to us,thanks a lot....
ReplyDeleteThanks a Lot .I has worked
ReplyDeleteThank you so much.. This fixed my issue :)
ReplyDelete