| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | |
|---|---|---|---|---|---|---|---|---|---|
Host a report server database in a SQL Server failover cluster |
Host a report server database in a SQL Server failover cluster |
kfollis |
kfollis |
09/25/2024 |
reporting-services |
report-server |
conceptual |
|
[!INCLUDEssNoVersion] provides failover clustering support so that you can use multiple disks for one or more [!INCLUDEssNoVersion] instances. Failover clustering is supported only for the report server database; you can't run the Report Server service as part of a failover cluster.
To host a report server database on a [!INCLUDEssNoVersion] failover cluster, the cluster must already be installed and configured. You can then select the failover cluster as the server name when you create the report server database in the Database Setup page of the [!INCLUDEssRSnoversion] Configuration tool.
Although the Report Server service can't participate in a failover cluster, you can install [!INCLUDEssRSnoversion] on a computer that has a [!INCLUDEssNoVersion] failover cluster installed. The report server runs independently of the failover cluster. If you install a report server on a computer that is part of a [!INCLUDEssNoVersion] failover instance, you aren't required to use the failover cluster for the report server database. You can use a different [!INCLUDEssNoVersion] instance to host the database.