SQL Server requirements and recommendations for Microsoft Dynamics CRM

  • Article

 

Applies To: Dynamics CRM 2015

These requirements apply to new and existing installations of SQL Server:

  • Microsoft Dynamics CRM requires an instance of Microsoft SQL Server Reporting Services be installed, running, and available. All installations of the supported SQL Server editions can be used as the reporting server. However, the Reporting Services edition must match the SQL Server edition.

  • Microsoft Dynamics CRM Server isn’t supported on Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft SQL Server 2008, or 32-bit versions of Microsoft SQL Server 2012.

  • Microsoft Dynamics CRM Server is not supported with SQL Server that is running on Windows Server 2008, Windows Server 2003 or Windows 2000 Server.

  • When Microsoft Dynamics CRM Server and SQL Server are installed on different computers, they must be in the same Active Directory domain.

  • Microsoft Dynamics CRM Server Setup and Deployment Manager support the default instance or a named instance of SQL Server.

  • Although you can install SQL Server by using either Windows Authentication or mixed-mode authentication, Windows Authentication is a prerequisite for Microsoft Dynamics CRM.

  • The service account that SQL Server uses to log on to the network must be either a domain user account (recommended) or the Network Service account (you can’t use a local user account on the server). Using a low-privilege account strategy is recommended to help avoid compromising the security of the server.

  • The SQL Server service must be started. This service should be configured to automatically start when the computer is started.

  • SQL Server Agent must be started. This service should be configured to automatically start when the computer is started.

  • SQL Server Full-Text Search must be installed and started. This service should be configured to automatically start when the computer is started.

  • Microsoft Dynamics CRM Server Setup requires a network library to authenticate SQL Server. By default, TCP/IP network libraries are enabled when you install Microsoft SQL Server. SQL Server can use both TCP/IP or Named Pipes for authentication. However, the computer that is running SQL Server must be configured for at least one of the two network libraries.

  • We recommend that the computer that is running SQL Server be located on the same local area network (LAN) as the computer that is running the Microsoft Dynamics CRM Server Back End Server roles. For a description of the server roles, see Microsoft Dynamics CRM server roles.

  • The computer that is running SQL Server must be configured to have sufficient disk space, memory, and processing power to support the Microsoft Dynamics CRM environment. For more information, see Microsoft Dynamics CRM Server 2015 hardware requirements_deleted.

  • Although it’s optional, consider accepting the SQL Server default settings for Collation Designator, Sort Order, and SQL Collation. Microsoft Dynamics CRM supports the following collation orders:

    • Case-sensitive

    • Case-insensitive

    • Accent-sensitive

    • Accent-insensitive

    • Binary sort order (such as Latin1_General_100_BIN)

    Note

    Microsoft Dynamics CRM sets the collation order at the database level. This setting might differ from that set at the SQL Server level.

  • Review all SQL Server installation options and be prepared to make the needed selections when you run Setup. For more information, see Installation for SQL Server 2012.

  • If you plan to install SQL Server in a location other than the default file location, see File Locations for Default and Named Instances of SQL Server.

    You should also consider where the Microsoft Dynamics CRM databases are located on the server, and the hard-disk configuration that will support them.

    Note

    To achieve the best combination of disk fault tolerance and performance, consider the many specifications for redundant array of independent disks (RAID) available from hardware vendors. Format the disks where the SQL Server database files reside for the fault-tolerance requirements of the application and performance parameters for the I/O activity occurring on that partition.

See Also

SQL Server installation and configuration
SQL Server deployment

© 2016 Microsoft Corporation. All rights reserved. Copyright