SQL Server 2016 and Dynamics NAV


SQL Server 2016 released in June this year with many new and interesting capabilities. For further information, please take a look at the product information at this location: https://www.microsoft.com/en-us/cloud-platform/sql-server

Over the last few months, the 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 2016,
  • Microsoft Dynamics NAV 2015,
  • Microsoft Dynamics NAV 2013 R2, and
  • Microsoft Dynamics NAV 2013

are compatible with the SQL Server 2016 database engine. This applies to the following editions of SQL Server:

  • Express Edition
  • Standard Edition
  • Enterprise Edition

Microsoft Dynamics NAV 2017 will be compatible with SQL Server 2016 at launch.

Note: For reports, please do not install the SQL Server 2016 SSRS components (Report Builder and Report Viewer) , as these currently will not work with Dynamics NAV RDLC reports. For more information, see the system requirements for reports in Dynamics NAV 2016 (you can navigate to earlier versions from that page).

Comments (17)

  1. Hallo navteam,

    is it possible and supported to use Microsoft Dynamics NAV 2015 with the Basic Availability Groups from the SQL Server Standard 2016?

    https://msdn.microsoft.com/en-us/library/mt614935.aspx

    Thank you.

    Best regards,
    Dennis

    1. Kennie Nybo Pontoppidan says:

      Dear Dennis Neumann,

      I have talked to our support engineers, and they informed me that we have several customers running NAV on SQL Server with databases in AlwaysOn availability groups. So: yes, it is possible to use Basic Availability Groups.

      Regards,
      Kennie Nybo Pontoppidan

  2. Kees_S says:

    Hi NAVTeam,
    Since the SQL Server 2016 SSRS components currently aren’t supporting the reports;
    Will it be possible to run NAV2016 on SQL server 2016 (database engine) and work with SQL Server 2014 SSRS components? So use SQL version 2014 reports(builder and viewers) for the time being…or will the mix of versionnumbers clash?

    Also, in time, will SQL Server 2016 SSRS components support the NAV2016 RDLC reports?!

    Thank in advance,
    Kees

    1. Kennie Nybo Pontoppidan says:

      Hi Kees,

      Yes, it is possible and supported to run NAV2016 on SQL server 2016 (database engine) and work with SQL Server 2014 SSRS components. For now, please do not install SQL Server 2016 SSRS components side by side with a NAV2016/2017. In an upcoming CU, we will make sure that NAV is using the SQL Server 2014 SSRS components, even though SQL Server 2016 SSRS components are installed.

      As to whether NAV RDLC reports will support SQL Server 2016 SSRS components, we still need to investigate some more.

      Regards,
      Kennie Nybo Pontoppidan

      1. Micha says:

        Hi Kennie Nybo Pontoppidan

        Has this change already been implemented in a CU or is NAV 2013 (R2) compatible with SSRS 2016 by now?
        If not, how would you suggest installation of SQL 2016 with SSRS 2014?

        Thanks in advance!

  3. Ninan George says:

    Hi there,

    Question about SQ Server 2016 SP1.
    Is NAV 2015 compatible with SQL Server 2016 SP1?

    1. Hi Ninan George,

      Yes, supported versions of NAV is supported on SQL Server 2016 SP1

      Regards,
      Kennie Nybo Pontoppidan

  4. Mariana M says:

    Hi NavTeam, can I have an official statement about the compatibility of Nav 5.0 SP1 with SQL Server 2016? Thanks in advance

    1. Pallea says:

      Hi Mariana

      Nav 5.0 SP1 has reached its end of llifecycle so that is not going to happen. Please read here:

      https://blogs.msdn.microsoft.com/nav/2011/12/18/mainstream-support-for-microsoft-dynamics-nav-5-0-ends-april-2012/

      Thanks
      Palle

    2. As Pallea writes, Nav 5.0 SP1 reached its end of mainstream support in April 2012

  5. ioannis says:

    NAV 2009 + SQL Server 2016 ?

    1. Thomas Hansen says:

      Dynamics NAV 2009 is also out of main stream support and are therefor have not been tested for compatibility.

  6. M Mukherjee says:

    Can Dynamics NAV 2016 Web Client directly access the SQL Server placed in Azure Cloud, while the Dynamics NAV 2016 server is installed in premises server?

    1. Hi M Mukherjee,

      All access to the database goes through the Dynamics NAV service

  7. himanshu says:

    hello Nav Team,

    Good Day!

    My client is using 2009 6.0(6.00) version with sql 2005 and want to upgrade there windows server to 2012 and Sql to 2016 with Nav 2009.

    Can 2016 sql server support 2009 W1 6.0 ??
    Can window server support 2005 sql.??

    Please suggest the best solution.

    Thanks in Advcance 🙂

    1. Pallea says:

      @himanshu read the text above your question!

      https://mbs.microsoft.com/customersource/northamerica/NAV/support/support-news/MainstreamSupportNAV2009

      Best solution is to to stay where you are or upgrade to Dynamics NAV 2017.

Skip to main content