We’ve decided that SQL Repository are going to start recording some SQL development videos for YouTube. I am preparing the PC for these videos and wanted to install SQL Server Reporting Services (SSRS) 2012. However, once the installation had completed and I navigated to Report Manager, I found the following error waiting for me!
User ‘MainPC\David’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
I thought that I would share the fix, as I know others will run into this error at some point.
- Right click the Internet Explorer icon and click ‘Run as Administrator’
- Navigate to your Report Manager site. The default is http://localhost/ReportServer/
- In the top right hand corner click ‘Site Settings’
- Click on the ‘Security’ tab on the left side
- Click ‘New Role Assignment’ and add your PC profile name (account name)
- Check the ‘System Administrator’ role, you can also add ‘System User’ if you wish
- Now save it
- Click on the ‘Home’ link in the top left corner
- On the main nav bar, click ‘Folder Settings’
- Click ‘New Role Assignment’ and add your PC profile name (account name)
- Check all of the options in here
- Now save it
- Close Internet Explorer, restart it and then navigate to Report Manager again
Leave a Comment