topic Re: Error with creating Data Store item in ArcGIS Enterprise Questions

Error with creating Data Store item

LClark1102 — Fri, 10 Oct 2025 16:26:13 GMT

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!

Re: Error with creating Data Store item

RyanUthoff — Fri, 10 Oct 2025 16:56:22 GMT

I think you're on the right track with that being the issue. It sounds like the DB is at a version too high for the currently installed ODBC drivers to be able to support. So the correct solution would be to review what version of SQL Server the client is using, then install the corresponding/supported ODBC drivers.

At minimum, the client would need to check the version of SQL Server and the version of the ODBC driver installed on the ArcGIS Server machine to determine if there is any incompatibility. If there is an incompatibility, then installing a compatible ODBC driver should fix the issue. Otherwise, there might be another issue going on. But the first step would be to confirm the SQL Server and ODBC driver version.

Re: Error with creating Data Store item

CodyPatterson — Mon, 13 Oct 2025 11:47:29 GMT

Hey @LClark1102

In combination with Ryan's answer, the customer should have access to the my.esri.com account which would allow them to access these downloads here:

The error you're receiving is very close to my own when I had forgotten to install the ODBC driver, I would reach out to their IT or support and have them verify this, I would say to try and programmatically reach out to a listener on the machine, but I believe ODBC does not do this!

Cody

Re: Error with creating Data Store item

LClark1102 — Mon, 13 Oct 2025 13:30:02 GMT

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

Re: Error with creating Data Store item

Priya_Das — Tue, 28 Oct 2025 19:29:52 GMT

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.

Re: Error with creating Data Store item

LClark1102 — Thu, 30 Oct 2025 16:14:22 GMT

@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!