Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Where is sql server reporting service virtual folder hosted?

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?

like image 532
smwikipedia Avatar asked Apr 08 '13 03:04

smwikipedia


2 Answers

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

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

like image 146
Arun6445 Avatar answered Nov 11 '22 05:11

Arun6445


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.

like image 34
Mike D. Avatar answered Nov 11 '22 04:11

Mike D.