topic Database connection using ArcGIS Desktop 10.3 to SQL Server in Data Management Questions

Database connection using ArcGIS Desktop 10.3 to SQL Server

Syvertson — Mon, 30 Mar 2015 21:52:58 GMT

I have two computers with ArcGIS Desktop 10.3 loaded. One is a new install. I am trying to connect to a SQL Server database on the new computer using exactly the same credentials that worked on the first computer. What can be different on this computer that would cause the issue. The error message says something about an older version of SQL Server Client. Is there something else I need to install other than the base ArcGIS Desktop 10.3 software?

Re: Database connection using ArcGIS Desktop 10.3 to SQL Server

JeffWard — Mon, 30 Mar 2015 22:23:55 GMT

You probably need the SQL Server Native Client installed. I think there is a disk with DBMS support files if you requested a hard copy, or there should be a download available.

Hope that helps,

Jeff

Re: Database connection using ArcGIS Desktop 10.3 to SQL Server

JoshuaBixby — Mon, 30 Mar 2015 22:40:27 GMT

The error message indicates a SQL Server client is installed, just an older one that isn't compatible with the version of SQL Server on the other end.

I suggest installing the Microsoft® ODBC Driver 11 for SQL Server® - Windows. I believe Esri is now packaging both the newer Microsoft ODBC Driver 11 and the older Native Client, but Microsoft has stopped updating the ODBC driver that is part of Native Client since they are moving forward using ODBC as the standard for native access to SQL Server and Windows Azure SQL Database.

Re: Database connection using ArcGIS Desktop 10.3 to SQL Server

JayantaPoddar — Tue, 31 Mar 2015 04:19:38 GMT

Hi Matthew,

What ver. of MS SQL Server are you using? And what is the ver. of the MS SQL Server Native Client?

Make sure the ver. of Native Client is same or higher than the Database Server. Also consider the service packs.

Thanks,

Jay

Re: Database connection using ArcGIS Desktop 10.3 to SQL Server

Syvertson — Tue, 31 Mar 2015 14:11:10 GMT

Thanks so much. I had the disk for installing database support and simply forgot to install it. Once I did, all is well.

Re: Database connection using ArcGIS Desktop 10.3 to SQL Server

Anonymous User — Thu, 10 Dec 2015 21:06:00 GMT

Can you please tell us from WHERE the native client can be downloaded? It sure would be appreciated. Thanks.

Re: Database connection using ArcGIS Desktop 10.3 to SQL Server

JoshuaBixby — Sat, 12 Dec 2015 18:54:48 GMT

From my earlier comment in this thread:

I suggest installing the Microsoft® ODBC Driver 11 for SQL Server® - Windows. I believe Esri is now packaging both the newer Microsoft ODBC Driver 11 and the older Native Client, but Microsoft has stopped updating the ODBC driver that is part of Native Client since they are moving forward using ODBC as the standard for native access to SQL Server and Windows Azure SQL Database.

If you are dead set on using Native Client, it is packaged with the SQL Server Feature Pack. If you visit the Microsoft® SQL Server® 2012 Feature Pack download page, expand the "Install Instructions" section, and scroll a ways down; you can download only the SQL Server Native Client.

Re: Database connection using ArcGIS Desktop 10.3 to SQL Server

RickGeittmann — Wed, 03 Feb 2016 23:55:59 GMT

Log into the customer care portal and you an download them from there