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 ArcGIS - ArcEditor 10 ArcGIS - ArcInfo 10 ArcGIS - ArcView 10
Platforms:  Windows 2003Server, Vista, 2008Server, Win 7

Error Message

Connecting from ArcGIS Desktop or another ArcSDE client to an ArcSDE 10 personal, workgroup, or 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

ArcSDE 10 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 did not understand new data types introduced in the newer databases. This also supports Microsoft’s recommendation in this regard.

The following rules now apply:

1. SQL Server Native Client software is required to connect to SQL Server 2005 or 2008 geodatabases. The MDAC (Microsoft Data Access Component) delivered with the Windows operating system is not sufficient.

a. A connection to SQL Server 2008 requires the SQL Server 2008 Native Client.

b. A connection to SQL Server 2005 requires the SQL Server 2005 Native Client or the SQL Server 2008 Native Client.

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

Solution or Workaround

Install the appropriate SQL Server Native Client software.

The SQL Server 2008 Native Client is automatically installed when setup.exe is run for ArcGIS Desktop 10, ArcGIS Server 10 or ArcReader 10. (For information on performing a silent install of ArcGIS software and the SQL Server Native Client, see the installation guides located on the software media.)

The SQL Server 2008 Native Client can also be downloaded from the following location: Microsoft SQL Server 2008 Feature Pack, August 2008. The download is entitled "Microsoft SQL Server 2008 Native Client".

Esri recommends using the SQL Server 2008 Native Client with either SQL Server 2005 or 2008. However, if connections are only being made to SQL Server 2005 geodatabases, the SQL Server 2005 Native Client can be used instead. It is available for download at the following location: Feature Pack for Microsoft SQL Server 2005 - February 2007. The download is entitled "Microsoft SQL Server Native Client".





    Created: 10/14/2009
    Last Modified: 6/29/2010

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

    Comments

    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: