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: http://www.microsoft.com/en-us/server-cloud/products/sql-server/default.aspx.

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 (24)

  1. Vectork says:

    Cool!!

  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. Roberto Stefanetti says:

    Great!

  5. R Shukla says:

    Great!

  6. 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!"

  7. 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 :)

  8. Leo says:

    Is SQL 2014 compatible to NAV 2015?

  9. SeverGr says:

    Dear all,

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

    Thanks for your answers.

  10. 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.

  11. SeverGr says:

    @Pallea,

    Thanx, I will stay at SQL 2008 R2.

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

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

  13. navblog 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.

  14. Antonio Loscalzo says:

    Hi –

    can you run SQL 2012 Runtime on NAV 5.0?

  15. Steven says:

    Hi,

    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

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

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

    -Steven

  16. 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

  17. Roque says:

    Is it compatible with NAV 2009 SP1?

    Thanks

  18. Naveen says:

    Is sql sever2014 will support urbancode build and urbancode deploy

  19. 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.

  20. 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.

  21. Jan Aagaard says:

    Hello
    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.