Export (0) Print
Expand All

SQL Server editions

[Applies to: Microsoft Dynamics CRM 4.0]

Any one of the following Microsoft SQL Server editions is required and must be installed, running, and available for Microsoft Dynamics CRM:

  • Microsoft SQL Server 2005, Standard Edition with SP3
  • Microsoft SQL Server 2005, Enterprise Edition with SP3
  • Microsoft SQL Server 2005, Developer Edition with SP3
  • Microsoft SQL Server 2005, Workgroup Edition with SP3
  • Microsoft SQL Server 2005, Standard Edition, x64 with SP3
  • Microsoft SQL Server 2005, Enterprise Edition, x64 with SP3
  • Microsoft SQL Server 2005, Developer Edition, x64 with SP3
  • Microsoft SQL Server 2008, Standard Edition
  • Microsoft SQL Server 2008, Enterprise Edition
  • Microsoft SQL Server 2008, Standard Edition, x64
  • Microsoft SQL Server 2008, Enterprise Edition, x64

    Important

    • Deployments that use SQL Server 2008 may require one or more updates to be installed on the computer that is running SQL Server 2008 to work with Microsoft Dynamics CRM. If they are needed, these updates will be installed when you click Update installation files during Microsoft Dynamics CRM Server Setup and Microsoft Dynamics CRM Connector for SQL Server Reporting Services Setup. For more information about these updates see KB article 957053: Support for running Microsoft Dynamics CRM 4.0 together with Microsoft SQL Server 2008.
    • Microsoft SQL Server 2008, Workgroup Web, Compact, or Express editions are not supported for running Microsoft Dynamics CRM.
    • SQL Server 2000 editions are not supported for Microsoft Dynamics CRM.
    • SQL Server that is running on Windows 2000 Server is not supported for Microsoft Dynamics CRM.
    • Commercially reasonable support will be provided when you run Microsoft Dynamics CRM with 64-bit SQL Server versions for Itanium (IA-64). Commercially reasonable support is defined as all reasonable support efforts by Microsoft Customer Service and Support that do not require Microsoft Dynamics CRM code fixes.
    • Microsoft Dynamics CRM Server now supports a named instance of SQL Server when you add or create organization databases.
    • You must install the cumulative update package 2 for SQL Server 2005 on the SQL Server when you use SQL Server 2005, Workgroup Edition.
    • SQL Server 2005, Workgroup Edition is supported only if Microsoft Dynamics CRM is installed on Small Business Server.
    • SQL Server 2005, Workgroup Edition is not supported for running the Microsoft Dynamics CRM Connector for Microsoft SQL Server Reporting Services when Microsoft Dynamics CRM Server is installed as an Internet-facing deployment. This is because SQL Server 2005 Workgroup Edition does not support custom data extensions. Therefore, some features such as report scheduling will not work.

© 2011 Microsoft Corporation. All rights reserved.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft