SQL Server installation and configuration
Applies To: CRM 2016 on-prem
To plan your use of Microsoft SQL Server with Microsoft Dynamics CRM Server, you must understand how Microsoft Dynamics CRM uses SQL Server, and what Microsoft Dynamics CRM Server Setup does and does not do:
Microsoft Dynamics CRM Server requires SQL Server 64-bit versions for storing the databases that contain Microsoft Dynamics CRM data and metadata. For specific details, see SQL Server editions.
Reports in Microsoft Dynamics CRM depend on Microsoft SQL Server Reporting Services, a feature in SQL Server. Reporting Services includes two server components that are used to store, display, and manage reports: Report Server and Report Manager. A third component, Report Builder, is used to customize reports and write new reports. The Report Designer component is available for download on the Microsoft Download Center and is installed on a workstation, instead of on the computer that is running SQL Server.
Microsoft Dynamics CRM Server Setup does not install SQL Server database engine or Microsoft SQL Server Reporting Services.
There are many configurations possible based on your expected usage of Microsoft Dynamics CRM. For information about the feature implications when you install Microsoft SQL Server Reporting Services on a separate computer, see Editions and Components of SQL Server.
Although we do not recommend it, you can install SQL Server on the same computer as Microsoft Dynamics CRM Server. For better performance, install and run SQL Server on a separate dedicated computer. For better performance and improved availability, install and run SQL Server on separate multiple dedicated computers in a clustered configuration. For more information, see Set configuration and organization databases for SQL Server 2012 AlwaysOn failover.
Similarly, we recommend that you install Microsoft Dynamics CRM Reporting Extensions on a separate SQL Server that is running Microsoft SQL Server Reporting Services. However, if needed you can install Microsoft Dynamics CRM Reporting Extensions on a SQL Server that is running Microsoft SQL Server Reporting Services but also stores the Microsoft Dynamics CRM databases.
Although, in a multiple organization deployment of Microsoft Dynamics CRM, you can specify different Reporting Services servers or server instances when you create or edit an organization, only one instance of Reporting Services is supported for all organizations in the deployment. For better load balancing of reports, we recommend configuring Report Server in a Network Load Balancing (NLB) cluster. For more information, see Configure a Report Server on a Network Load Balancing Cluster.
Multiple Microsoft Dynamics CRM front-end servers that run in a network load balancing cluster can use the same computer that is running SQL Server.
Send comments about this article to Microsoft.
© 2015 Microsoft. All rights reserved.