High availability in SQL Server Reporting Services

A Reporting Services report server is a stateless server that stores application data, content, properties, and session information in two SQL Server relational databases. As such, the best way to ensure the availability of Reporting Services functionality is to do the following:

  • Use the high availability features of the SQL Server Database Engine to maximize the uptime of the report server databases. If you configure a Database Engine instance to run in a failover cluster, you can select that instance when you create a report server database.

  • Use SQL Server Always On availability groups with the Reporting Services databases and for data sources, as possible. For more information, see Reporting Services with Always On Availability Groups.

  • Configure multiple report servers to run in a scale-out deployment, where all the servers share a single report server database. Deploying multiple report server instances, preferably on different servers, in a scale-out deployment can help provide uninterrupted service in the event one of the report server instances goes down.

A scale-out deployment provides a way to share a database. If one report server goes down, other servers in the same deployment will continue to work.

Reporting Services is not cluster-aware. By itself, a scale-out deployment does not provide load balancing; it does not detect the processing loads on a report server and route new processing requests to the least busy server. It does not re-route processing requests that failed before completion. To get load balancing features, you must configure load balancing for the Web servers that host the report servers, and then configure the report servers in a scale-out deployment so that they share the same report server database.

The Report Server Web service and Windows service are tightly integrated and run together as a single report server instance. You cannot configure availability for one service separately from the other.

More questions? Try asking the Reporting Services forum