Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Support for Microsoft Dynamics CRM with Microsoft SQL Server 2012


View products that this article applies to.

More Information

Microsoft Dynamics CRM 4.0 (Update Rollup 21) and Microsoft Dynamics CRM 2011 (Update Rollup 6) are compatible with Microsoft SQL Server 2012. 

Note Microsoft Dynamics CRM 4.0 and Microsoft Dynamics CRM 2011 support installing and running Dynamics CRM on Microsoft SQL Server 2012. Microsoft SQL 2012 has a new feature called Always On. There are no plans to support Always On or any other new Microsoft SQL 2012 features with Microsoft Dynamics CRM 4.0. However, this has been tested and is supported with Microsoft Dynamics CRM 2011:

Set configuration and organization databases for SQL Server 2012 AlwaysOn failover

Issues that may occur when using Microsoft Dynamics CRM 4.0 with Microsoft SQL 2012
  • After upgrading to Microsoft SQL Server 2012 you will need to reinstall the Microsoft Dynamics CRM Data Connector. The custom binaries do not get brought over during the upgrade so the Microsoft Dynamics CRM Data Connector need to be reinstalled.
  • When running a report you get the following error.
    "The report cannot be displayed."

    Currently there is no workaround and a hotfix is in progress.

Issues that may occur when using Microsoft Dynamics CRM 2011 with Microsoft SQL 2012

  • After upgrading to Microsoft SQL Server 2012 you will need to reinstall the Microsoft Dynamics CRM Reporting Extensions. The custom binaries do not get brought over during the upgrade so the Microsoft Dynamics CRM Reporting Extensions need to be reinstalled.
  • When using Microsoft SQL Server 2012 Express with the Microsoft Dynamics CRM Client for Microsoft Office Outlook you get the following error.
    CrmSqlStartupSvc:SqlShutdownEvent cannot stop service of SQL Express with as "SQL Express service could not be stopped".

    This issue has been fixed in Update Rollup 8. http://support.microsoft.com/kb/2600644

↑ Back to the top


Keywords: kbtshoot, kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2686619
Revision : 2
Created on : 3/30/2017
Published on : 3/30/2017
Exists online : False
Views : 247