8

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?

Improve this question

3 Answers 3

Reset to default
11

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

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

Improve this answer
1
  • Thank you. Following the pattern, mine was in MSRS13.MSSQLSERVER for SQL Server 2016.
    – gknicker
    Commented Jul 21, 2018 at 14:30
5

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.

Improve this answer
6
  • Thanks. That tutorial is for 2008 R2, but I am using SSRS 2012. And I cannot even open the mybox.org/ReportServer, but the tutorial needs me to click the 'site settings' on that page.
    – smwikipedia
    Commented Apr 8, 2013 at 5:00
  • and btw, do you know where the ReportServer virtual folder is physically located?
    – smwikipedia
    Commented Apr 8, 2013 at 5:01
  • If SSRS is running on your computer try using localhost instead of mybox.org. The location of the folder on your hard drive that contains the files for report manager depends on your SQL server installation. Just do a file search for a folder named "ReportManager" it should be somewhere under the SQL server folder in program files. (I've only checked on a 2008 R2 server. I don't have access to a SQL 2012 server.)
    – Mike D.
    Commented Apr 8, 2013 at 5:22
  • I tried "dir ReportServer /s" "dir Reports /s" on all my disks, found nothing. That's why I am confused. Also, I have tried localhost. (The mybox.com is just a placeholder because stackoverflow doesn't allow an URL contains localhost.)
    – smwikipedia
    Commented Apr 8, 2013 at 6:27
  • Report manager's default location isn't at server/ReportServer, try using /Reports and see if it loads up. Also make sure you're running the browser as administrator so that you'll login as that.
    – Mike D.
    Commented Apr 8, 2013 at 6:41
1

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

Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.