Knowledge Base - Technical Articles


Technical Article   Error:  Connection was attempted with an older version of SQL Server client communications software that is not compatible with the SQL Server database server

Article ID: 37287
Software:  ArcSDE 10, 10.1, 10.2, 10.2.1, 10.2.2 ArcGIS - ArcEditor 10 ArcGIS - ArcInfo 10 ArcGIS - ArcView 10 ArcGIS Server (10.0 and prior) 10 ArcGIS for Desktop Advanced 10.1, 10.2, 10.2.1, 10.2.2 ArcGIS for Desktop Standard 10.1, 10.2, 10.2.1, 10.2.2 ArcGIS for Desktop Basic 10.1, 10.2, 10.2.1, 10.2.2 ArcGIS for Server 10.1, 10.2, 10.2.1, 10.2.2
Platforms:  Windows Server 2003, Vista, Server 2008, Windows 7, Windows 8, Server 2012, Server 2008 R2, Windows 8.1, Server 2012 R2

Error Message

Connecting from ArcGIS Desktop or another ArcGIS client to an enterprise geodatabase hosted on SQL Server returns the following error message:

"Connection was attempted with an older version of SQL Server client communications software that is not compatible with the SQL Server database server."

Cause

ArcGIS enforces the rule that the database client software that manages communication between the application and SQL Server is at least as new as the SQL Server instance to which it is connecting. This eliminates a group of problems that arise when the database client software does not understand new data types introduced in the newer databases. This also supports Microsoft’s recommendation in this regard.

The following rules now apply:

• SQL Server Native Client software is required to connect to SQL Server 2012 or earlier geodatabases.

• The SQL Server Native Client must be the same version, or a newer version than the version of SQL Server you are connecting to.

• A connection to a Windows Azure SQL Database requires the Microsoft ODBC Driver 11 for SQL Server. This driver can also be used to connect to any 10.2.x geodatabase on SQL Server 2008, 2008R2 or 2012.

• The SQL Server Native Client software must be installed on any Windows machine from which a connection is made. This includes on ArcSDE servers to support an application server connection.

Solution or Workaround

Install the appropriate SQL Server client communication software.

Both the Microsoft ODBC Driver 11 for SQL Server and the SQL Server Native Client are available for download from Microsoft.



    Created: 10/14/2009
    Last Modified: 5/29/2014

    Article Rating: (6)
    If you would like to post a comment, please login

    Comments

    By marcelo.villarroel - 10/10/2014 5:51 AM

    Great article! It helped a lot!

    Rating:

    By pml - 08/13/2014 2:54 AM

    The article is incorrect or the solution didn’t work.

    The error message was incorrect about the versions of SQL Server client and SQL Server. My client is newer than the version of SQL Server yet this error message still appeared. Perhaps ArcGIS Desktop and ArcGIS Server want a version of SQL client that is newer than the one I have.

    Rating:

    By fleith - 09/17/2013 6:37 AM

    The article needs to be updated.

    Can you please update this article to reflect the changes to connections via ArcGIS 10.1 sp1 & 10.2 clients... I presumed the SQL Server Native Client 2008 was installed with the 10.1 software (this statement can be confusing... "The SQL Server 2008 Native Client is automatically installed when setup.exe is run for ArcGIS Desktop 10, ArcGIS Server 10 or ArcReader 10") why would you remove this at a higher version (I guess it is a licensing thing) Clarification of this article is necessary.

    Rating:

    By msilin - 01/16/2013 7:44 AM

    The article needs to be updated.

    Great article. Solution works. It's just that the link to the SQL Server client is broken. 64-bit version of the client can be found here: http://go.microsoft.com/fwlink/?LinkID=188401&clcid=0x409

    Rating:

    By konzelt - 01/07/2013 2:24 PM

    The article is incorrect or the solution didn’t work.

    This should be included as an option in the typical setup, not left for every user to be found after they've already installed and about to start testing/using the software.

    Rating:

    By rich6626 - 11/28/2012 12:17 PM

    Other - See details below.

    This article is being updated. The URL to the SQL Server 2008 (R2, SP2) Feature Pack is: http://www.microsoft.com/en-us/download/details.aspx?id=30440. The download is entitled 'Microsoft SQL Server 2008 R2 Native Client'. The file name is 'sqlncli.msi'.

    By cquinn@ofallon.org - 11/27/2012 6:51 AM

    The article is incorrect or the solution didn’t work.

    The link to MSQL Server Feature Pack, http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en, does not resolve. I am trying to get Native SQL Client 2008 for 64-bit OS Windows.

    Rating: