How to: Verify a Reporting Services Installation

When you install a report server using the default configuration, Setup installs and deploys the server. You can verify whether Setup deployed the report server by performing a few simple tests. You must be a local administrator to perform these steps. To enable other users to perform testing, you must configure report server access for those users. For more information about how to configure user access, see Tutorial: Setting Permissions in Reporting Services in SQL Server Books Online.

Note

The Reporting Services tutorials can help you learn important skills quickly. There is also a tutorial that introduces each tool. It explains how to start the tool and shows you how each tool looks when it first opens. You can use this tutorial to confirm that all the tools installed correctly. For more information, see Tutorial: How to Locate and Start Reporting Services Tools in SQL Server Books Online.

To verify that the report server is installed and running

  • Run the Reporting Services Configuration tool and connect to the report server instance you just installed. The Web Service URL page includes a link to the Report Server Web service. Click the link to verify you can access the server. If the report server database is not configured, do that first before clicking the link.

  • Open the Services console applications and verify that the Report Server service is running. To view the status of the Report Server service, click Start, point to Control Panel, double-click Administrative Tools, and then double-click Services. When the list of services appears, scroll to Report Server (MSSQLSERVER). The status should be Started.

  • Open a browser and type the report server URL in the address bar. The address consists of the server name and the virtual directory name that you specified for the report server during setup. By default, the report server virtual directory is named ReportServer. You can use the following URL to verify report server installation: http://<computer name>/ReportServer<_instance name>. The URL will be different if you installed the report server as a named instance. For more information about the URL format, see Configuring Report Server URLs. If you are a local administrator on Windows Vista or Windows Server 2008, see How to: Configure a Report Server for Local Administration on Windows Vista and Windows Server 2008 (UAC).

  • Run reports to test report server operations. For this step, you can install and publish the sample reports if you do not have any reports available. For instructions on how to install sample databases, applications, and data files that are used in Reporting Services tutorials, see Initial Installation (Reporting Services) in SQL Server Books Online.

To verify that Report Manager is installed and running

  • Open a browser and type the Report Manager URL in the address bar. The address consists of the server name and the virtual directory name that you specified for the Report Manager during setup or in the Report Manager URL page in the Reporting Services Configuration tool. By default, the Report Manager virtual directory is Reports. You can use the following URL to verify Report Manager installation: http://<computer name>/Reports<_instance name>.

  • Use Report Manager to create a new folder or upload a file to test whether definitions are passed back to the report server database. If these operations are successful, the connection is functional.

To verify that Report Designer is installed and running

  • Open Business Intelligence Development Studio, and create a new project based on a Report Server project type. For more information on using the Report Server Project Wizard, see How to: Add a New or Existing Report to a Report Project (SSRS) in SQL Server Books Online.

  • If you installed report samples, open the sample report project files and publish the reports to a report server. For more information, see Publishing Models in SQL Server Books Online.