Error with creating Data Store item

Question

Hello,

I am attempting to set up a data store on a client's Enterprise portal. I am using a connection to an enterprise geodatabase that the client is also hosting.

After I upload the SDE connection file and click Next, I get an "Error" message after the validation test. I used my browser's developer tools and found that the actual error message is "The connection property set was missing a required property or the property value was unrecognized. Connection was attempted with an older version of SQL Server client communications software that is not supported."

This leads me to believe that the issue is possibly due to ODBC drivers not being installed on the client's machines hosting Portal/Server/DataStore components, but I'm not exactly sure. Unfortunately, I don't have access to the client's hosting machines, so I'm unable to check or do anything myself.

I am wondering if anyone here has a better idea or could possibly confirm my suspicions. I wanted to try to figure out the steps needed to correct this issue, so that I can pass them on to the client.

Any assistance would be appreciated!

datastore_error.png

LClark1102 · Answer

@Priya_Das Thanks for the tips. Unfortunately, after confirming everything, the issue is still present. They are going to put in a support ticket with Esri. Hopefully, they can get things sorted.

But I appreciate the assistance from everyone!

Priya_Das · Answer

Hi @LClark1102,

Verify SQL Server version compatibility. Refer to this doc: https://enterprise.arcgis.com/en/server/latest/manage-data/windows/connect-sqlserver.htm

Install the latest supported Microsoft ODBC Driver for SQL Server:

* For ArcGIS Enterprise 11.x, Microsoft ODBC Driver 17 or 18 is typically required.
*  Download from Microsoft’s official site.

Ensure the driver is installed on all relevant machines:

* ArcGIS Server
*  ArcGIS Data Store (if used)
* Any machine where the SDE connection file is validated or used

Restart ArcGIS Server services after installation to ensure the new driver is picked up.

LClark1102 · Answer

@RyanUthoff @CodyPatterson : I really appreciate the input. I'll reach out to them for confirmation that the drivers are installed. Hopefully, it's that simple. I'll keep you guys updated.