I installed the SSRS 2012 and tried visit http://mybox.org/Reports, but get an error saying:
User 'mybox\xxx' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed
So I tried to check the IIS settings. But astonishingly found that in my IIS 8 management console, there's no Reports site or virtual folder. So, where is the Reports being hosted? And how to troubleshoot this permission error?
Physical directory of reportserver and report manager can be found under:
\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services
SSRS 2008 doesn't need IIS to work anymore. It sounds like that error is coming straight from SSRS and not the web server anyway. You need to give your account (MYBOX\xxx) access using the report manager interface. (SSMS can no longer be used to grant rights for report manager).
You'll need local administrator access to the machine that SSRS is installed on since it automatically has system-wide admin rights in report manager. Then you just navigate to http://localhost/reports
and give \MYBOX\xxx whatever security permissions you need.
An MSDN tutorial on user rights management in SSRS.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With