topic Re: connection was attempted with an older version of SQL Server client communications software that is not supported in ArcGIS Desktop Installation Support Questions

connection was attempted with an older version of SQL Server client communications software that is not supported

AlexSainz — Mon, 21 Nov 2016 21:53:39 GMT

I received the following error message when attempting to connect to a SQL Server 2008 database from ArcGIS Desktop 10.4.1.

Error Message:

Unable to connect to database server to retrieve database list; please verify your server name, user name and password info and try again. Connection was attempted with an older version of SQL Server client communications software that is not supported.

Re: connection was attempted with an older version of SQL Server client communications software that is not supported

DerekLaw — Mon, 21 Nov 2016 22:18:35 GMT

Hi Alex,

Please review this Esri KnowledgeBase Article,

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

Hope this helps,

Re: connection was attempted with an older version of SQL Server client communications software that is not supported

RebeccaStrauch__GISP — Mon, 21 Nov 2016 22:26:41 GMT

I haven't updated to 10.4.x yet, but I remember that 2008 was not on the list for supported SQL platforms. How much this plays into connecting and read-only (vs trying to create) I do not know.

Microsoft SQL Server database requirements for ArcGIS 10.4.x—Help | ArcGIS for Desktop

Re: connection was attempted with an older version of SQL Server client communications software that is not supported

RebeccaStrauch__GISP — Mon, 21 Nov 2016 22:56:01 GMT

NOTE: Even though Derek Law‌ 's link doesn't list/include 10.4.1, I just install the

Microsoft_SQL_Server_2012_SP3_Native_Client_64bit_149470 version of the client on my test 10.4.1 machine, and I was able to connect to what I believe is a SQL 2008 (SP4) SDE database....other than drawing something quickly, I did not test any further.

...this is critical for me before I upgrade too.

Re: connection was attempted with an older version of SQL Server client communications software that is not supported

AlexSainz — Mon, 21 Nov 2016 22:56:34 GMT

Derek and Rebecca,

When reviewing the technical requirements for ArcGIS Desktop 10.4.x I noticed that SQL Server 2008 was not on the list of supported SQL platforms - Rebecca pointed this out as well. Thank you to Derek for providing the KB article to verify this information. I installed SQL Server 2012 Native Client on a test machine and was able to add a connection to a SQL Server 2008 R2 database.

Hopefully this will help someone else in a similar situation. Our organization is currently in the process of modernizing many of our enterprise applications to the most current version possible. SQL Server is likely next as we migrate away from SQL Server 2008 R2.

Re: connection was attempted with an older version of SQL Server client communications software that is not supported

AlexSainz — Mon, 21 Nov 2016 23:01:52 GMT

Thank you for your help Derek and Rebecca.

Rebecca - good luck on your upgrade.

Re: connection was attempted with an older version of SQL Server client communications software that is not supported

BillFox — Mon, 21 Nov 2016 23:33:43 GMT

Highlight v10.4 vs. 10.4.1

Editing issues upgrading from 10.3.1 to v10.4.x prompted this upgrade workflow:

Upgrade SQL Server from 2008 R2 to 2014 SP 2

ArcGIS Desktop 10.3.x and 10.4 clients
Continue using the Microsoft SQL Server Native Client 2012
Or, if they have trouble connecting
Need to install the Microsoft ODBC Driver v11

ArcGIS Desktop 10.4.1 clients
Need to install the Microsoft ODBC Driver v13

-Bill

Re: connection was attempted with an older version of SQL Server client communications software that is not supported

BillFox — Mon, 21 Nov 2016 23:36:26 GMT

Additional upgrade info about ArcGIS & SQL Server compatibility levels:

https://community.esri.com/message/647666-re-arcsde-sql-server-compatibility-level?commentID=647666#comment-647666

pml‌