Configuring Reporting Services for Scale-Out Deployment

SQL Server Setup

Scale-out deployments are used to increase scalability of report servers to handle more concurrent users and larger report execution loads. It can also be used to dedicate specific servers to process interactive or scheduled reports. Scale-out deployments consist of:

  • Two or more report server instances sharing a single report server database.
  • Optionally, a network load-balanced (NLB) cluster to spread interactive user load across the report server instances.

When deploying Reporting Services on an NLB cluster, you need to ensure the NLB virtual server name is used in the configuration of report server URLs and that servers are configured to share the same view state.

Reporting Services does not participate in Microsoft Cluster Services clusters. However, you can create the report server database on a Database Engine instance that is part of a failover cluster.

To plan, install, and configure a scale-out deployment, follow these steps:

See Also

Concepts

URLs in Configuration Files (Reporting Services)
Considerations for Installing Reporting Services

Other Resources

Planning a Deployment Topology
Hosting a Report Server Database in a SQL Server Failover Cluster
Configuration Files (Reporting Services)
Reporting Services Components and Tools