Export (0) Print
Expand All

SQL Server requirements and recommendations for Microsoft Dynamics CRM

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 2013 isn’t supported on Microsoft SQL Server 2000, Microsoft SQL Server 2005, or 32-bit versions of Microsoft SQL Server 2008 and Microsoft SQL Server 2012.

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

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

  • Microsoft Dynamics CRM Server Setup and Microsoft Dynamics CRM 2013 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 2013 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 2013 hardware requirements in this guide.

  • 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)

    noteNote
    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.

    noteNote
    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.

  • If you are using an operating system with regional settings other than English (United States), or if you are customizing character-set or sort-order settings, review topics on collation settings. For more information, see International Considerations for SQL Server.

See Also

Send comments about this article to Microsoft.

© 2014 Microsoft Corporation. All rights reserved.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft