Install Microsoft Dynamics CRM Server 2013 to use a Microsoft SQL Server 2008 cluster environment


Applies To: Dynamics CRM 2013

You can install Microsoft Dynamics CRM Server 2013 so that it can use a clustered Microsoft SQL Server 2008 environment that uses Windows Server failover clusters.


Failover clustering is not supported with Microsoft SQL Server 2008 Workgroup.

This section describes the options that are available to configure Microsoft Dynamics CRM Server to use a clustered SQL Server 2008 environment. The base configuration for a Microsoft Dynamics CRM Server 2013 system is described previously in this guide. The instructions in this topic expand on the base configuration by installing Microsoft Dynamics CRM Server 2013 so that it has a connection to a cluster of computers that are running SQL Server.

The configuration described here involves a single deployment of Microsoft Dynamics CRM Server 2013 accessing a cluster of two computers that are each running an instance of Microsoft SQL Server 2008.

The typical Microsoft Dynamics CRM deployment creates and uses the following Microsoft Dynamics CRM-specific databases on SQL Server:

  • OrganizationName_MSCRM. This is the organization database where Microsoft Dynamics CRM data is stored, such as all records and activities.

  • MSCRM_CONFIG. This database contains Microsoft Dynamics CRM metadata, such as configuration and location information, that is specific to each organization.