Reporting Services permissions on SQL Server R2 SSRS
You need to set permissions within SSRS in two places to give yourself initial access. The set-up program only gives access to Builtin\Administrators, to gain access in order to do this you need to right click you browser link and choose Run as administrator.
- Run internet explorer as Administrator
- Open the report Manager URL, this time you should get in
- Go to Site Settings in the top right
- Click Security then New Role Assignment
- Enter your domain\username and select System Administrator, click ok
- Add other users as necessary
- Click home, Folder Settings, then New Role Assignment
- Enter your domain\username and select Content Manager, click ok
- Add other users as necessary
- Re-open internet explorer (non-admin) and recheck the url.
This did the trick for me. http://thecodeattic.wordpress.com/category/ssrs/. Go down to step 35 to see the error you are getting. Paraphrasing:
Once you're able to log in to YourServer/Reports as an administrator, click Home in the top-right corner, then Folder Settings and New Role Assignment. Enter your user name and check a box for each role you want to grant yourself. Finally, click OK. You should now be able to browse folders without launching your browser with elevated privileges.
Don't forget to set the security at the site level **AND ** at the folder level. I hope that helps.
Rick