SQL Native Client 11 ISSUE

(0) Share

Report

Posted on by sdcraig

366

My customer is on GP 2015 and Windows 10 - GP does not launch so I went to the 32-bit ODBC and when we hit the Configure button nothing happens. if we hit the Add Button the screen comes up and we hit SQL Native Client 11 the next screen does not come up. If I select SQL Server, the screen comes up. I then downloaded SQL Native Client 11 but we got the message that it is not supported on the operating system. I am trying to get more info from them, the IT person was not familiar with GP, so they did not know the version of SQL or the name of the server it was on. I am trying to figure out what version of Native Client 11 I can use the link to the site below is the one that gave me the error.

Download Microsoft® ODBC Driver 11 for SQL Server® - Windows from Official Microsoft Download Center

I have the same question (1)

All responses (1)

Answers (0)

Suggested answer

Derek Albaugh Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

The Microsoft SQL Server 2012 Native Client QFE patch is the main one that GP would require to be able to connect to SQL 2012 or later should TLS 1.0 be disabled and what we've had success in with this type of DSN issues.

Microsoft SQL Server 2012 Native Client - QFE > SQL Server 2012 Native Client (11.0.7001.0)

The link is here:

www.microsoft.com/.../details.aspx

As it mentions in the notes at the bottom of this page:

Note that Microsoft will not be releasing a SQL Server 2014 or later version of the SQL Server Native Client. The SQL Server 2012 Native Client (v11, e.g. sqlncli11.dll), can continue to be utilized by SQL Server 2014 and later versions.

On this server where the ODBC DSN will not connect to SQL, try uninstalling the existing SQL Native Client driver from Control Panel > Programs and Features, then install this new SQL Native Client driver onto the server.

Once you do that, test the existing DSN to see that it now connects to SQL as expected. If so, then you should also be able to login to Dynamics GP.

Was this reply helpful? Yes No