Compatibility with SQL Server 2014

SQL Server 2014 released earlier this year with many new and interesting capabilities. For further information, please take a look at the product information at this location:

Over the last few months, the Microsoft Dynamics NAV team has been testing compatibility with this new version of SQL Server, and we are now proud to announce that Microsoft Dynamics NAV 2013, Microsoft Dynamics NAV 2013 R2, Microsoft Dynamics NAV 2009 R2, and Microsoft Dynamics NAV 2009 SP1 are compatible with SQL Server 2014!

Please note that this applies to the following editions of Microsoft SQL Server:

  • Standard Edition
  • Enterprise Edition

Best regards,

The Dynamics NAV team


—– This blog post was updated on September 22, 2014. —–

Comments (26)

  1. Vectork says:


  2. Henrik Ohm says:

    Thank you for being ahead of time 🙂 Looking forward to 2009R2 tests.

  3. Johannes Gudmundsson says:

    Great news!  I can finally answer this popular question with a YES

  4. R Shukla says:


  5. kakanox says:

    Henrik Ohm:

    "we are now proud to announce that Microsoft Dynamics NAV 2013, Microsoft Dynamics NAV 2013 R2, >>>> and Microsoft Dynamics NAV 2009 R2 <<<< are compatible with SQL Server 2014!"

  6. Jens Glathe says:

    Great. ONE usable release of NAV is copatible with SQL Server 2014. That's good news and bad news in one sentence. Hey, at least it's compatible 🙂

  7. Leo says:

    Is SQL 2014 compatible to NAV 2015?

  8. SeverGr says:

    Dear all,

    Does anyboy know if NAV 5.0 SP1 is compatible with SQL Server 2014?

    Thanks for your answers.

  9. Pallea says:

    @SevenGr – As NAV 5.0 SP1 has been "terminated" long time ago (April 10th, 2012) the short answer is No.

    The little longer answer is that NV 5.0 SP1 is capable of running on Level 90 – So you could give it a shot trying to run on SQL 2014 with Level no higher than 90 – But I guess all the amazing stuff that SQL 2014 can do…will not work for your installation. This is considered as a bad idea to go in this direction.

    IF you want to go stick to your 5.0 SP1, then you should do a runtime upgrade on your client-machines and server to Dynamics NAV 2009R2. You will still be 5.0 SP1 Objects, but your runtime NAV will support SQL 2014, and you should be safe.

    You WILL get some performance out of it, BUT as the code has not been changed to use FINDFIRST/FINDLAST and FINDSET (and not FIND('-') and FIND('+')) then your performance might end up being limited depending on the rest of your server configuration.

  10. SeverGr says:


    Thanx, I will stay at SQL 2008 R2.

  11. NAV 5/ 2005 SP1 (version 95) SQL support says:

    Which is the latest/greatest version of SQL support by this version?

  12. navteam says:

    Hello all,

    As PalleA mentions, NAV 5.0 SP1 is long since out of mainstream support, so we have not tested compatibility with versions of SQL Server that are later than SQL Server 2008.

  13. Antonio Loscalzo says:

    Hi –

    can you run SQL 2012 Runtime on NAV 5.0?

  14. Steven says:


    is there any SQL 2014 enterprise feature in Scalability & Performance section such as:

    Table and index partitioning

    Data compression

    Resource Governor

    Partition Table Parallelism

    Multiple Filestream containers

    NUMA Aware Large Page Memory and Buffer Array Allocation

    IO Resource Governance

    In-Memory OLTP 1

    (…/cc645993.aspx) that might be used in NAV 2015?

    we are still confused which version of SQL that we need to buy.


  15. Chen says:

    Thanks for the info!

    How about NAV 2015? Does it compatible with SQL 2014 AlwaysOn? It will be a very important feature for NAV database availability.

    1. Cedric Roesti says:

      have you find an answer to that question ?
      and if yes how to do so

  16. Roque says:

    Is it compatible with NAV 2009 SP1?


  17. Naveen says:

    Is sql sever2014 will support urbancode build and urbancode deploy

  18. Cedric Roesti says:

    Is Nav 2016 compatible with the Always on feature of the SQL 2014 Enterprise ?
    if yes, how to replicate the [$ndo$srvproperty] from one fail over server to the other Fail over master database.

  19. hi team
    Is SQL Server 2016 compatible to NAV 2015 and NAV 2016 ?

    Thanks !

    1. Peter says:

      I have read elsewhere, that this is not expected to be officially supported until the August CU. However; I have used NAV2016 (CU5 and CU8) for dev and test on SQL2016 without any issues yet.

  20. Jan Aagaard says:

    Do you have any information on how the Microsoft Dynamics NAV 2009 R2 will Work with the just released Microsoft SQL Server 2016?

    1. Peter says:

      Why don’t you just try it? You will never get an official statement as NAV2009 isn’t supported anymore.

  21. Victor Isakov says:

    I too would like to know the state of NAV 2009 R2 on SQL Server 2016.

    The difference between SQL Server 2014 and SQL Server 2016 for what NAV does should be minimal. In fact upgrading to SQL Server 2016 should be less risky than upgrading to SQL Server 2014.

    I’m note sure why people are saying that it is no longer supported. According to NAV 2009 R2’s Extended Support End Date is 1/14/2020.


  22. Roeland says:

    Thats great news. We are in the process of upgrading a Nav 2009R2 Database from 2008 to SQL 2014 (so upgrade DB only). What would be your advice of changing the Compatibility Level after attaching the 2008 DB in 2014? Thank You!