Failover is not supported in a Microsoft SQL Server Reporting Services cluster environment
Published: May 4, 2007
You can install and run the Microsoft SQL Server Reporting Services service and associated databases used by Microsoft Dynamics CRM to a single node in a Microsoft Windows Server failover cluster. There are several components involved when you run Microsoft Dynamics CRM reports: however, the SQL Server Reporting Services reporting components cannot provide failover support when they are clustered.
On This Page
You can configure failover support for the SQL Server Reporting Services databases that are used by Microsoft Dynamics CRM. This failover support is provided by the Windows Server clustering feature. However, this feature cannot provide failover support for the SQL Server Reporting Services service or the Web service.
SQL Server Reporting Services failover cluster configurations that are supported
When you deploy a SQL Server Reporting Services server on a single node in a SQL Server failover cluster, the cluster must already be installed and configured. Then, when you create the SQL Server Reporting Services database, you can specify the failover cluster name as the server name that will host the database.
Note
Although the SQL Server Report Services service and Web service cannot participate in a failover cluster, you can install SQL Server Reporting Services on a computer that has a SQL Server failover cluster installed. The services will run independently of the failover cluster.
Alternatively, if you install SQL Server Reporting Services on a computer that is part of a SQL Server failover instance, you do not have to use that failover cluster for the SQL Server Report Services database. You can use a different instance of SQL Server to host the database.
SQL Server Reporting Services failover cluster configurations that are not supported
Do not deploy both SQL Server Report Services and the reporting services databases on each node of a multi-node cluster. Moreover, do not deploy SQL Server Reporting Services in a two-node cluster environment that consists of an active node and a passive node where the passive node becomes active during a failover.
For more information about SQL Server Reporting Services deployment in a clustered environment, see the MSDN article Planning a Reporting Services Deployment.
