Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

SQL Native Client 11 ISSUE

Posted on by 353

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

  • Suggested answer
    RE: SQL Native Client 11 ISSUE

    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans