I am trying to access the report manager url for SSRS. But, I keep on getting the error below -
User mycomputer\myloginName does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
I tried to run my browser as admin as described here - User '' does not have required permissions, SSRS 2008 on Windows 8
with no success. I also don't see the 'site settings' on top-right corner as mentioned by so many people. Also, I cannot go through the pain of reinstalling SQL server all over again. I don't want to disable UAC.
I am unable to do anything because of this problem.
How do I fix this problem?
This solution is for Internet Explorer. I don't know how it can be done for firefox or chrome.
Link 1 -
http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/9b5a8763-84ce-46d0-b011-067ad39223d1/
See the solutions by Chirag Shah. Follow only up to step 13. I could not follow Step 14 because I found no home dialog box.
In the steps Chirag talks about some URL's. I don't really understand the meaning of any of those URL's. So, I used the URL under "Report Manager URL" in "Reporting Services Configuration Manager". It was
http://localhost:8080/MyReportServer.
The 8080 is a port number.
Once you finished this, go to the link below and follow all the steps -
http://www.soheib.com/technical-knowledge/sql-server-2012-reporting-services-uac-user-access-control/
In the 7th step, I saw a lot of check boxes. I selected all of them.
Finally, I can rest in peace. Hope it works for you too.
Also, when making the accounts described in the above link, you might see "BUILTIN\Administrators" account. Ignore it - thats what i did.
**END OF POST**
Steps taken from Chirag Shah's post -
- Configure the report server for local administration. To access the report server and Report Manager locally, follow these steps:
- Start Windows Internet Explorer.
- On the Tools menu, click Internet Options.
- Click Security.
- Click Trusted Sites.
- Click Sites.
- Under Add this Web site to the zone, type http://ServerName. If you are not using HTTPS for the default site, click to clear the Require server certification (https:) for all sites in this zone check box.
- Click Add.
- Repeat step 7f and step 7g to add the http localhost URL, and then click Close.
- Note This step enables you to start Internet Explorer and open either the localhost or the network computer name of the server for both the Report Server application and the Report Manager application.
- Create role assignments that explicitly grant you access together with full permissions. To do this, follow these steps:
- Start Internet Explorer together with the Run as administrator option. To do this, click Start, click All Programs, right-click Internet Explorer, and then click Run as administrator.
- Open Report Manager. By default, the Report Manager URL is http://ServerName/reports. If you use SQL Server Express with Advanced Services SP2, the Report Manager URL is http://ServerName/reports$sqlexpress. If you use a named instance of Reporting Services, the Report Manager URL is http://ServerName/reports$InstanceName
i was receiving blank page after i was logging exactly 3 times on my report server URL.
i've Turn Off Internet Explorer Enhanced Security. On different OS's it is in different location. find the location and turn it off.
I hope this will help you.
