Connect to sql server 2012 using Native Client 10.5

Question

We are currently moving from SQL Server 2008R2 to SQL Server 2012.

For sql 2012 we started to use AG. One of our application is running on Windows Server 2003 and using natibve client 10.5

As it is WS 2003 we cannot install Native Client 11 (it is supported only begin with WS 2008)

So question is - is it possible to connect to database on SQL Server 2012 using Native Client 10.5?

p.s. as I understood I cannot use AG in connection string, but at least is it possible to connect or not?

Regards

Answer 1

Hello,

Based on the following article, it seems not possible:

http://msdn.microsoft.com/en-us/library/hh510238.aspx

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Although not supported, you can technically connect to SQL 2012 using Native Client 10.5, it doesn't error.  However, you will not get any SQL 2012 features, like AG.

I would highly recommend upgrading your OS to WS 2008+ instead.