Title says it all, what is the most recent version of Sql Server native client that is compatible with Sql Server 2008 R2


Microsoft SQL Server Native Client 11.0 is the latest and is backward compatible with 2008 and 2008R2 (as of July 9 2019, both windows and sql server 2008 and 2008r2 are fully unsupported).

BOL warns you :

The SQL Server Native Client (SQLNCLI) remains deprecated and it is not recommended to use it for new development work. Instead, use the new Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) which will be updated with the most recent server features.

  • The fun thing is, after i asked this question, i found out that 11.0 doesnt support windows xp, and unfortunately we have test equipment we have not upgraded yet, Thanks for the quick answer. – KySoto Aug 19 '19 at 15:57
  • @KySoto Your test equipment is running XP? Is production running XP too? Otherwise how much faith do you put in your tests? – Aaron Bertrand Aug 19 '19 at 17:27
  • we have pieces of equipment that can ONLY run on xp, it cant get on the internet, but obviously if something sneaks in, that computer would be vulnerable to it. on some of the applications running, it was homebrew code that a former engineer wrote, but bailed out on us. it takes a lotta time to replace. – KySoto Aug 19 '19 at 18:05

SQL Server 2008 R2 is out of support, but AFAIK every existing SQL Server client library, including all SNAC and ODBC drivers should work fine with that version.

  • Thanks for the quick reply, sadly we just dont have the cash to update to a newer version of sql server (im pushing!) – KySoto Aug 19 '19 at 15:55

I believe, there is no version beyond SQL Server native client 11.0 which you can use for SQL Server 2008

  • Didnt realize you could connect to sql server 2018 with native client 11.0, neat bit of trivia. – KySoto Aug 19 '19 at 15:56
  • 1
    @KySoto, sorry for the typo mistake, corrected! – Shekar Kola Aug 19 '19 at 16:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.