Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies®

IX.B.10. Where Are My Reports?

After setting up an SQL Server Reporting Services (SSRS) server, it's common to "lose" the URL you need to access the reports. The actual URL you use depends on whether SSRS is installed in the default instance of SQL Server or a named instance.

You can access both the report server (which lists all your reports) and the Report Manager (which allows you to manage many of your reports) via Web browsers.

• Finding SSRS on a default instance: To access the SSRS report server (which lists all your reports) on a server named SRV1, use the following URL:

  http://SRV1/ReportServer

  To access the Report Manager (which allows you to manage your reports) on a server named SRV1, use this URL:

  http://SRV1/Reports

• Finding SSRS on a named instance: When accessing an SSRS that's installed on a named instance, you need to add the instance name to the end of the URL preceded by an underscore.

  For example, if your named instance were MyReports on a server named SRV1, the URL for the report server would be:

  http://SRV1/ReportServer_MyReports

  To access the Report Manager on a server named SRV1 with a named instance of MyReports, use this URL:

  http://SRV1/Reports_MyReports