SSRS Permissions Issue after fresh Installation (Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed)

Posted by Ram on March 1, 2014 Leave a comment (0) Go to comments

Normally during the SSRS installation along with other components we give default service accounts by clicking on “Add current user” and then proceed with the installation steps.

After the installation is over, then we go to start –> all programs –> SQL Server –> configurattion tools –> reporting services configuration manager –> to set service account, web service URL, report manager URL etc.,

Finally when you go to reportmanager URL like http://localhost/reports/, you may see this error for the first time

“User ‘‘ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.”

To resolve this we have 2 solutions:

1) open IE in administrator mode and then click on URL to open the reports. But this will become tedious everytime to right-click and open as admin in IE.

2) To fix it permanently, open IE in admin mode, go to site settings and then security tab, click on “new role assignment”.

Here you will observe 2 role groups, “System Administrator” and “System User”.

Give your domain account as sysadmin and may be any another user who needs more privileges as system user.

Then click on home and then go to “folder settings” click on “new role assignment” and give the sysadmin you have chosen before as content manager and the system user as publisher or browser.

Now when you go to either reportmanager or reportserver URL, you will have not have Windows UAC restrictions issue anymore.