Interesting one today:
Setting up a new SSRS machine on one of the virtual machines in our lab, we ran into this interesting error after walking through the initial steps of install & configuration. Turns out, this is a common error after fresh installs. Following is the error message:
The permissions granted to user are insufficient for performing this operation. (rsAccessDenied) Get Online Help
Following steps have helped resolve it.
SSRS service runs under the security of a user account; My guess is that this account needs permissions to access the content on the SSRS site & folders. So we need to carry out two steps to assign proper permissions.
- Folder Permissions
- Site Permissions
- Trusted Site Settings
Open browser with Administrative Privileges and point it to Reports Manager URL. Go to ‘Folder Settings’.
In the properties page, go to the Security tab and click on ‘New Role Assignment‘
In the new page, add the user account for ‘Group or User Name’ field. Then assign ‘Content Manager‘ permissions to the user account. And hit okay to save the settings.
Use the same browse (with administrative permissions), to go to Site Settings on the right.
In the settings page, go to Security tab and click on New Role Assignment.
In the new page, add the windows user to the ‘Group or user name’; Assign System Administrator role and hit OK.
Trusted Site Settings
Go to Internet Explorer, Tools -> Internet Options -> Security tab > Click on Trusted Sites. In the new window, enter the URL for Report Manager and close.
Now you can open browser and open Report Manager without any security warning.
Once the permissions are set, close the browser and re-open it without administrative permissions. Going forward, it would work without needing to open browser with elevated permissions.
For more information, please refer to this BoL article.