ODBC connection to SQL Server 2012

 What

Errors when trying to make an ODBC connection to SQL Server 2012.

 Problem

When trying to make an ODBC connection from an MS Windows 2008 R2 server to an SQL Server 2012 we encoutered an error.

 Solution

When you can find your SQL Server 2012 on your LAN, and make a connection to it, you could receive authentication errors. You checked of course your user and tcp/ip settings but this seems obviously right than you could have the same problem like I had.

To connect to the MS SQL Server 2012 you need to have the right SQL Client. You need the SQL Native client 11 version.

You can download this with following hyperlink (I included the x86 client also):

x86 Package http://go.microsoft.com/fwlink/?LinkID=239647&clcid=0x409
x64 Package http://go.microsoft.com/fwlink/?LinkID=239648&clcid=0x409