The following are the guidelines specific to SQL Server instance to be used for CRM 2015 platform:

  • Don’t modify system tables on the SQL instance where Dynamics CRM is to be deployed.
  • Full-text indexing must be installed.
  • CRM organization databases have auto growth setting of 256MB. For intensive database transactions increase the auto growth value to improve performance.
  • Set Max degree of parallelism to 1 in SQL Server to improve the overall application performance on multiprocessor systems.

Dynamics CRM platform creates two databases:

  • MSCRM_CONFIG: Contains the CRM metadata, such as configuration and location information specific to each organization database.
  • OrganizationName_MSCRM: The main organization database where CRM data is stored viz., entity (aka table) records, activities etc. There will be several of these organization databases depending on the number of the organizations setup using CRM Deployment Manager.

SQL Server Connection & SSRS:

  • Dynamics CRM connection to SQL Server is only via Windows Authentication.
  • Dynamics CRM Reporting Extensions are data processing extensions and are installed on the Microsoft SQL Server Reporting Services server. Two data processing extensions: Fetch data processing extension for Fetch-based reports and SQL data processing extensions.
  • The identity account running the instance of Microsoft SQL Server Reporting Services must be added to PrivReportingGroup AD security group.
  • Separate deployments of Microsoft Dynamics CRM cannot share one SQL Server Reporting Services server. But a single deployment of Microsoft Dynamics CRM can use the same SQL Server Reporting servers.