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

11406
4
08-16-2013 11:45 AM
Highlighted
Occasional Contributor III
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
Reply
0 Kudos
4 Replies
Highlighted
Regular Contributor
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
Highlighted
New Contributor II

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).

Reply
0 Kudos
Highlighted
New Contributor II

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

Reply
0 Kudos
Highlighted
New Contributor

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 t... 

Reply
0 Kudos