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

  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