SQL Server requirements and recommendations for Microsoft Dynamics CRM
Updated: November 1, 2016
Applies To: Dynamics 365 (on-premises), Dynamics CRM 2016
[This topic is pre-release documentation and is subject to change.]
The following requirements and recommendations apply to new and existing installations of SQL Server.
Microsoft Dynamics CRM Server 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.
For a list of supported SQL Server versions, see SQL Server editions.
Microsoft Dynamics CRM Server isn’t supported with SQL Server that’s running on Windows Server 2008 or Windows Server 2003.
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.
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.
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:
Binary sort order (such as Latin1_General_100_BIN)
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.
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.
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.
We recommend that Common Runtime Language (CLR) be enabled on the SQL Server that hosts the Microsoft Dynamics CRM organization database. CLR can show a significant improvement in performance for some features such as time zone conversions when you run dashboards, charts, advanced finds, and Microsoft Dynamics CRM interactive service hub experience. More information: Enabling CRL Integration
© 2016 Microsoft. All rights reserved. Copyright