Before you install Microsoft Dynamics CRM Server 2011, you should understand the following:
- Microsoft SQL Server can be, but is not required to be, installed on the same computer as Microsoft Dynamics CRM Server 2011.
- If Microsoft Dynamics CRM Server 2011 and SQL Server are installed on different computers, both computers must be in the same Active Directory directory service domain.
- SQL Server can be installed by using either Windows authentication or mixed-mode authentication. (Windows authentication is recommended for increased security and Microsoft Dynamics CRM will use only Windows authentication).
- The service account that SQL Server uses to log on to the network must be either a domain user account (recommended) or the local system account. Installation of Microsoft Dynamics CRM will fail if the SQL Server service account is the local administrator.
- The SQL Server service must be started and can be configured to automatically start when the computer is started.
- The SQL Server Reporting Services service must be started and configured to automatically start when the computer is started.
- The SQL Server Agent service must be started. This service can be configured to automatically start when the computer is started.
- Although it is optional, we recommend that you accept the SQL Server default settings for Collation Designator, Sort Order, and SQL Collation. Microsoft Dynamics CRM supports both case-sensitive and case-insensitive sort orders.
- Microsoft Dynamics CRM Server Setup requires at least one network protocol to be enabled to authenticate by using SQL Server. By default, TCP/IP protocol is enabled when you install SQL Server. You can view network protocols in SQL Server Configuration Manager.