The ‘Mainstream Support End Date’ for Microsoft Dynamics NAV 2009 R2 has ended on 1/13/2015. As you already may know you can find this info on Microsoft Lifecycle Policy. All supported Products are listed here alphabetically and you can check the Lifecycle information per product. Really useful and easy to find info. So Microsoft Dynamics NAV 2009 R2 will not officially support SQL Server 2016.
Now the question will be… is it possible to run NAV 2009 on A SQL Server 2016 machine? I’ve investigated this question. I’ve installed SQL Server 2016 on Windows Server 2012 R2 (from scratch). Then I restored a NAV 2009 database (Dutch Cronus Database) and installed NAV from the NAV DVD. Result: NAV 2009 R2 does work with SQL Server 2016 as expected. However, I haven’t done intensive testing to say or guarantee that every aspect will function without problems. But at first glance, it looks to work fine at least with the Classic Client. However keep in mind: as long as Microsoft won’t support SQL Server 2016 for ‘the old’ NAV 2009 R2 you should be careful. For those who are interested in the details. The setup and the versions I’ve used:
A dedicated SQL Server: SQL Server 2016 version: 13.0.1601.5
A dedicated NAV Server: NAV 2009 R2 version: 6.00.32942
Both servers are running on Windows Server 2012 R2 as the OS (Build 9600).