Install Microsoft Dynamics CRM Server 2011 to use a Microsoft SQL Server cluster environment
You can install Microsoft Dynamics CRM Server 2011 so that it can use a clustered Microsoft SQL Server environment that uses Windows Server failover clusters.
Important
Failover clustering is not supported with Microsoft SQL Server 2008 Workgroup.
Base configuration
This topic describes the options that are available to configure Microsoft Dynamics CRM to use a clustered SQL Server environment. The base configuration for a Microsoft Dynamics CRM Server 2011 system is described previously in this guide. The instructions in this topic expand on the base configuration by installing Microsoft Dynamics CRM Server 2011 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 2011 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.
See Also
Concepts
Troubleshooting installation and upgrade
Option 1: Install a new Microsoft Dynamics CRM Server 2011 deployment