How to: Install a Local Report Server and Remote Report Server Database

Hosting a report server database on a remote SQL Server Database Engine instance requires additional configuration steps after setup is complete. You must have administrator permissions on both the local and remote computers. Both computers must be in the same domain or in a trusted domain.

The following procedure is for a Windows Server 2003 operating system. If you are using a different operating system, the steps may vary.

  1. Run Setup. For more information, see How to: Install SQL Server 2005 (Setup).

  2. In the Components to Install page, select Reporting Services. Click Next.

  3. In the Instance Name page, select Default Instance. Click Next.

  4. In the Service Account page, specify a domain user account. If you want to support scheduled operations, make sure that SQL Server Agent service starts automatically. In Start services at end of setup, select SQL Server Agent. Click Next.

  5. In the Authentication Mode page, specify Windows Authentication. Click Next.

  6. In the Report Server Installation Options page, select Install but do not configure the server. Click Next.

  7. In the Error and Usage Report Settings page, click Next.

  8. Click Install to begin installation.

  1. Click Start, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, click SQL Server Surface Area Configuration.

  2. In Surface Area Configuration for Services and Connections, verify that the Report Server Windows service is running.

  3. In Surface Area Configuration for Features, verify that Scheduled Events and Report Delivery is enabled. Verify that HTTP and Web Service Requests is enabled. Verify that Windows integrated security is enabled.

  4. Open Reporting Services Configuration. Click Start, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, click Reporting Services Configuration.

  5. Select the local report server instance you just installed. Click Connect.

  6. Configure the Web service account and virtual directories. If you are using Windows XP or Windows 2000 server, you must use the default ASP.NET account. If you are using Windows Server 2003, you can specify a custom account.

  7. Configure the database.

    1. Open the Database Setup page.
    2. In Server Name, select the remote SQL Server Database Engine instance, and then click Connect. You must have permission to create a database and configure roles on that server. The Reporting Services Configuration tool will use your credentials to create the database.
    3. Click New to create a new report server database. The SQL Server Connection dialog box opens. Type the name of the new database and the credentials used to create the database, and then click OK.
      If you already have a report server database you want to use, you can select it rather than create a new one. Click Upgrade if you want to upgrade a SQL Server 2000 report server database to the new schema. Upgrading the database is required if you want to use it with a SQL Server 2005 version of Reporting Services (note that you cannot reverse this step once the database has been upgraded; be sure that you have a backup copy of the database before you proceed).
    4. In Credentials Type, select the kind of account used to connect the report server to the report server database. You can use the service account credentials or a specific Windows domain account or SQL Server login.
    5. If you chose Windows Credentials or SQL Server Credentials, type the user name and password that the report server uses to connect to the report server database. For more information, see Configuring a Report Server Database Connection.
    6. Click Apply to save your changes.
  8. Configure other settings as needed, and then verify the installation. For more information, see How to: Verify a Reporting Services Installation.

Note that some editions and releases of SQL Server 2005 have different default settings for remote connections. If the report server cannot connect to the database, verify that remote connections are enabled. For instructions, see the section "How to Configure Remote Connections to the Report Server Database" in Configuring a Report Server for Remote Administration.

Community Additions