Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

CRM 8.2 on-prem Compatible with SQL Server 2019?

Jump to Best Answer
  • 1.  CRM 8.2 on-prem Compatible with SQL Server 2019?

    TOP CONTRIBUTOR
    Posted Jan 30, 2020 06:01 PM
    We want to upgrade our system databases to SQL Server 2019.
    I can't find information saying if Dynamics CRM On-premises ver 8.2 is compatible with SQL Server 2019 or not.
    Anyone know for sure?

    Note: Our CRM application server is Windows 2012 R2 but we don't have plans to upgrade that yet.

    ------------------------------
    Allison Briden
    Business Systems Analyst
    Energy Trust of Oregon
    Portland OR
    ------------------------------
    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: CRM 8.2 on-prem Compatible with SQL Server 2019?
    Best Answer

    SILVER CONTRIBUTOR
    Posted Jan 31, 2020 02:51 AM
    Edited by Jonathan Hoffman Jan 31, 2020 05:49 PM

    Hi Allison!  (No clue why I accidentally typed Natalie a second ago...oops!)

    I actually ran into this issue a few weeks ago, one of our clients upgraded their SQL Server to 2018, and they couldn't complete the configuration of their CRM environments because the last SQL Server version that 8.2 is compatible with is 2016.

    Here is some more information regarding compatibility:

    https://support.microsoft.com/en-gb/help/3124955/compatibility-with-microsoft-dynamics-crm-2016



    ------------------------------
    Jonathan Hoffman
    D365 CE Consultant
    Blue Horseshoe
    Carmel IN
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 3.  RE: CRM 8.2 on-prem Compatible with SQL Server 2019?

    TOP CONTRIBUTOR
    Posted Jan 31, 2020 05:49 PM
    Ugh, it's not good news!
    Now, is CRM 9.0 On-premises compatible with SQL Server 2019? (I know this would require Windows server upgrade, too)...​

    ------------------------------
    Allison Briden
    Business Systems Analyst
    Energy Trust of Oregon
    Portland OR
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 4.  RE: CRM 8.2 on-prem Compatible with SQL Server 2019?

    SILVER CONTRIBUTOR
    Posted Feb 01, 2020 12:01 PM
    Unfortunately, no.  9.0 is compatible with 2017, except for the reporting services, which are only 2016 compatible.

    ------------------------------
    Jonathan Hoffman
    D365 CE Consultant
    Blue Horseshoe
    Carmel IN
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 5.  RE: CRM 8.2 on-prem Compatible with SQL Server 2019?

    TOP CONTRIBUTOR
    Posted Feb 03, 2020 01:09 PM
    Thanks so much! That will help us with planning.
    It would be nice to know if Microsoft had plans (or no plans) to support Dynamics CE On-premises with the latest SQL Server and Windows Server versions. However, I suppose their focus is on supporting and making advancements with the Online implementations.​

    ------------------------------
    Allison Briden
    Business Systems Analyst
    Energy Trust of Oregon
    Portland OR
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 6.  RE: CRM 8.2 on-prem Compatible with SQL Server 2019?

    TOP CONTRIBUTOR
    Posted Mar 05, 2020 05:33 PM
    @Jonathan Hoffman - what in particular broke when your client upgraded to SQL Server 2019? I am putting together a test plan for running CRM 8.2  with SQL Server 2019 and ideas of what to look for would be helpful! Thank you!

    ------------------------------
    Allison Briden
    Business Systems Analyst
    Energy Trust of Oregon
    Portland OR
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


If you've found this thread useful, dive deeper into User Group community content by role