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.

Important

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

Base configuration

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.

In This Section

Option 1: Install a new Microsoft Dynamics CRM Server 2013 deployment

Option 2: Rehome or configure an existing Microsoft Dynamics CRM Server 2013 deployment that connects to a SQL Server cluster that stores only the organization database

Option 3: Rehome or configure an existing Microsoft Dynamics CRM Server 2013 deployment that connects to a SQL Server cluster that stores both the configuration and organization databases

See Also

Microsoft Dynamics CRM Server 2013 installation
Set configuration and organization databases for SQL Server 2012 AlwaysOn failover