Solved! Go to Solution.
- In order to connect to SQL Server 2012 you must use the SQL Server 2012 native client, i.e. you cannot use the SQL Server 2008 native client
No, the SQL Server Native Client 2008 should be able to connect too. I personally have connected using 2008 R2, but haven't tested the 2008 Native Client, with SQL Server 2012 yet.
The thing that I find confusing is the link to the SQL Server Native Client 11.0 article in that it does not list Windows 8 or Windows Server 2012 as being supported. I assume that that is just an oversight, correct?
No, it isn't.
It seems Microsoft recently decided to rename the SQL Server Native Client, and it is now called:
"Microsoft ODBC Driver 11 for SQL Server on Windows" (/ Linux in the Linux version).
Thanks for that information Shannon.
The question I have then is whether or not there is a SQL Native Client which supports Windows 8 and Windows Server 2012?
I don't see the newer operating systems listed:
http://msdn.microsoft.com/en-us/library/cc280356.aspx
If there is not one then I think that I am correct in saying that direct connect to SQL Server 2012 is not supported for the newer operating systems.
Can you comment as to whether or not there are changes in this regard for 10.2?