nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Database connection using ArcGIS Desktop 10.3 to SQL Server

Syvertson

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?

Find more posts tagged with

Accepted answers

JeffWard

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

All comments

RickGeittmann

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

JoshuaBixby

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.

Anonymous User

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

Syvertson

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

JayantaPoddar

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

JoshuaBixby

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.

JeffWard

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.