In this procedure, you will configure the SQL Server 2005 Report Server to make it functional.

Tasks

  1. Configure SQL Server Reporting Services

Configure SQL Server Reporting Services

Procedure W03-DWR.1: To configure the SQL Server 2005 Report Server

  1. On OMSQL01, select Reporting Services Configuration from Configuration Tools of Microsoft SQL Server 2005.

  2. On the Report Server Installation Instance Selection page, ensure that the Machine Name is OMSQL01.

  3. Ensure that the Instance Name is MSSQLSERVER, and then click Connect.

  4. Create a new Report Server Virtual Directory, accepting the default value.

  5. Create a new Report Manager Virtual Directory, accepting the default value.

  6. Set the Web Service Identity, accepting the default values for the Report Server and Report Manager application pools. Apply the settings.

  7. Set up the database, select OMSQL01 as the server name, select New for database name, and then accept the default values for SQL Server Connection. Apply the settings.

  8. Follow the on-screen instructions to complete the configuration.

  9. Restart the OMSQL01 server.