Enterprise , ArcGIS Pro and SQLServer compatibility

[Rohanrajan]

Good Day,

Enterprise Version: 11.4

ArcGIS Pro Version: 3.3

SQLServer Management Studio in Enterprise machine: 20.2.1

SQLServer Management Studio in ArcGISPro machine: 18.9.2

in Enterprise machine: Microsoft_ODBC_Driver_18_SQL_Server_64bit_192848

in ArcGIS Pro machine: Microsoft_ODBC_Driver_18_SQL_Server_64bit_192848

I am trying to publish a feature Service from an SDE using ArcGIS Pro 3.3

but while registering datastore, I get a validation error, Connection was attempted with an older version of SQL Server client communications software that is not supported.

Is the SSMS version in my ArcGIS Pro machine causing this? Or what else am i missing?

Any advice is much appreciated.

Thanks

[VinceAngelo]

Management Studio is a client to the SQL Server database, just like Pro, so it doesn't really have any role in enterprise geodatabase compatibility.  You don't state the database server version in use, so it's hard to determine compatibility, but that message seems to come from the database drivers, not from Esri components.

Note that it's recommended to upgrade your clients to the intended Enterprise version before upgrading the ArcGIS Server/Portal components, so you really ought to be running ArcGIS Pro 3.4 with Enterprise 11.4.

The software compatibility matrix is available in this FAQ topic.

- V

[Rohanrajan]

Hi,

I upgraded ArcGIS Pro to 3.4 and tried registering the datastore but the problem persists 

Any advice would be much appreciated.

Thanks

[Rohanrajan]

Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2022 Standard 10.0 <X64> (Build 20348: ) (Hypervisor)

This is the Server version. the FAQ page shows SQL Server 2019 is compatible with Enterprise 11.4

Upgrading to ArcGIS Pro 3.4 will rule out things I guess

[JoshuaBixby]

So when you say "Enterprise machine" are you saying that all ArcGIS Enterprise components are installed on one machine?  That is, one machine has ArcGIS Server, Portal for ArcGIS, ArcGIS Web Adaptors, and an enterprise geodatabase installed on it?  If that is not what you are saying, you need to elaborate on how ArcGIS Enterprise is deployed across its machines because the error you are seeing is coming from an ArcGIS Server machine (either as hosting server or federated GIS server).

[Rohanrajan]

Hi @JoshuaBixby , it is a multi machine deployment with separate servers for each components. Yes, The Server is federated.

And the ODBC Driver is installed only in the DBMS Server which has the SQLServer

ArcGIS Web Server

ArcGIS Server

ArcGIS Enterprise Portal

ArcGIS Enterprise Data-Store

DBMS Server

[wizgis · Accepted solution]

@Rohanrajan 

I guess the machine on which ArcGIS Server is installed has two ODBC drivers which might be causing a conflict. You can check from control panel if there are two ODBC drivers are installed on the ArcGIS Server machine. 

Here is a link that you can refer: https://support.esri.com/en-us/knowledge-base/error-the-connection-property-set-was-missing-a-requir... containing the additional causes of this error message.