topic Re: Connection was attempted with an older version of SQL Server client communications in Data Management Questions

Connection was attempted with an older version of SQL Server client communications

DiegoLlamas — Fri, 16 Aug 2013 18:45:18 GMT

Hi,

In my laptop I have installed ArcMap 10.1. I had to re install windows and after that I am not able to connect to a enterprise database. I got the error "Connection was attempted with an older version of SQL Server client communications software that is not compatible with the SQL Server database server" [ATTACH=CONFIG]26761[/ATTACH] I found this:
http://support.esri.com/en/knowledgebase/techarticles/detail/37287 But I'm not sure if I need to download The SQL Server 2008 Native Client (or the version of my SQL) and install it on my laptop. It has to be installed on the laptop, right? that is the main problem am I correct?

Thanks for your help!

Best regards,

Diego Llamas

Re: Connection was attempted with an older version of SQL Server client communication

LeoDonahue — Fri, 16 Aug 2013 19:14:19 GMT

You are correct. You need the SQL Server Native client on your laptop, matching the same version as your sql server. If your laptop is windows 7, install the x64 version of the sqlncli.exe

Re: Connection was attempted with an older version of SQL Server client communications

B_Kraan — Tue, 15 Mar 2016 10:36:53 GMT

This error also happens when the user is spelled wrong or the password is incorrect. Microsoft does provide us with an confusing errormessage which does not always describe the actual problem

I just spend half an hour being able to create a database connection without any problem using a full access account but having the 'incorrect sql native client' when using a read-only account (which turned out to be incorrectly spelled).

Re: Connection was attempted with an older version of SQL Server client communications

RobertoDeDeus — Wed, 15 Jun 2016 18:40:05 GMT

I had run into the same issue and that error message led me the think I was having an issue with the native client. But I had another geodatabase that was working fine so it had to be something else. Went back to read through some documentation and I realized that it was actually a permission problem.

"Registering your data does not grant the ArcGIS Server account permissions to access your data. Before registering your data, you'll need to ensure that the ArcGIS Server account has at least read permissions to the data stored in folders, in databases, or in enterprise or workgroup geodatabases that are accessed using operating system authentication. To learn more about this process, see Make your data accessible to ArcGIS Server."

About registering your data with ArcGIS Server—Documentation | ArcGIS for Server

Re: Connection was attempted with an older version of SQL Server client communications

VivianMurga1 — Wed, 22 Nov 2017 19:26:52 GMT

To correct this issue, I simply had to install the Microsoft ODBC Driver 11 for SQL Server.

Check out this link:

Error: Connection was attempted with an older version of SQL Server client communications software that is not compatibl…