How do I connect to sde on SQL Server 2014. I can't find a 2014 SQL Native Client and ArcCatalog won't connect with 2012 Native Client.

Question

How do I connect to an sde geodatabase on SQL Server 2014 from ArcCatalog 10.3? I can't find a 2014 SQL Native Client and ArcCatalog won't connect with 2012 Native Client. I get this error:

"Failed to connect to database.

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

ThibautDelaere1 · Answer

I had the same issue with ArcGIS for Server 10.3.1.

Solution is to use the MS ODBC instead of the Native Client.

Better Practice:  Connect to SQL Server from ArcGIS Using MS ODBC​

StevenGraf1 · Answer

I have had issues with other components of ArcGIS, specifically Server, where I installed SQL server native client after ArcGIS Server was installed and it wouldn't let me create a data store connection.  I had to completely reinstall Server to fix this.

I wonder if the same could be said about Desktop.  I would try reinstalling ArcGIS Desktop to see if it would fix the issue.

Also, I have been told repairing operations only replaces DLL files and such and may not fix the issue.

-Steven

jflorey · Answer

Hi Steven,

Thanks for the reply. I am using ArcCatalog 10.3. I found the same things you did. I do have Native Client 2012 installed on the machine, and ran a repair on it this morning just to make sure. It seems as though ArcCatalog doesn't recognize that the 2012 Native Client is valid for connection to 2014 SQL Server because the versions are different.

Regards,

Jay