Installing a Report Server Web Farm

Installing a Report Server Web Farm

SQL Server 2000

A report server Web farm is a collection of report server instances that share the same report server database. Reporting Services does not provide Web farm deployment functionality. To deploy Reporting Services in a Web farm, you can use network load balancing (NLB) functionality provided through Windows servers, Microsoft Application Center, or third-party software that supports Web farm deployment.

To create the report server nodes that will become part of a Web farm deployment, you use Setup. You must run Setup once on each computer that you want to join to a Web farm. The first time you run Setup, you install a report server instance and create the report server database that all of the report server nodes will use. When you run Setup to install additional report server instances, you select the existing report server database and the report server instance you initially installed.

In order to join a report server instance to a Web farm, several prerequisites must be in place.

  • A report server installation and a report server database must already exist.
  • The Reporting Services edition must be Enterprise, Developer, or Evaluation. Standard cannot be used in a Web farm.
  • The computer on which you are installing the report server must not already have an existing report server instance installed on it.
  • All of the computers in the Web farm must be in the same domain or in a trusted domain.

If these prerequisites are met, specify the name and server of an existing report server database during installation on the Report Server Database page, or in the RSDATABASENAME and RSDATABASESERVER properties specified in a command line statement. When you specify a database name that already exists, Setup assumes that a Web farm installation is being deployed and checks the edition and version of the product. If the product edition is Standard (which does not support Web farms), an error occurs and you will be prompted to provide a new database name.

If the edition supports Web farms and a connection to the existing database is validated, Setup displays the Report Server Web Farm Setup page. In this page, you must specify the name of the computer that hosts the report server instance that was created at the same time as the report server database.

Optionally, you can specify a Windows account to use to connect to the existing report server instance. If you are installing from the command line (by specifying the RSWEBFARMSERVER property in the command prompt), you can specify the Windows account through the RSWEBFARMACCOUNT and RSWEBFARMPASSWORD properties. If credentials are not specified, Setup connects using the security context of the user running Setup. Once all data is gathered, Setup activates the new report server installation into the Web farm. For more information on report server Web farms, see Enterprise Deployment Model.

See Also

Installing Reporting Services

Preparing to Install

Reporting Services Component Overview

© 2016 Microsoft