Is it possible to use SQL Server Native Clients from previous SQL Server releases (e.g. SQL Server 2008 R2 Natice Client) to connect SQL Server 2012 database?
Sql-server – Is it possible to use Native Clients from previous releases to connect SQL Server 2012
connectivitynative-clientsql serversql-server-2012
Related Question
- Sql-server – Connect to SQL Server 2012 from an Windows XP client
- SQL Server 2012 – How to Connect Client Applications to Cluster
- Sql-server – Reporting Services will not connect to SQL Server
- SQL Server 2012 – Compatibility Level 110 and SQL Server Native Client 10
- Sql-server – the latest version of SQL Server native client that is compatible with Sql Server 2008 r2
- Sql-server – SQL Native Client 11 – SQL Server 2017
- Sql-server – SQL Native Client Upgrade
Best Answer
Yes, although it's possible that some new functionality might not be supported by the older client. We have a number of programs using the 2008 Native Client to connect to 2012, and haven't observed any problems.