Where is sql server reporting service virtual folder hosted?

Question

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?

Answer 1

Physical directory of reportserver and report manager can be found under:

\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services

Answer 2

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.

Answer 3

For SQL Server 2017 the location pattern changed and now the default physical directory of ReportServer is:

C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer