Community
Select to view content in your preferred language

Error with creating Data Store item

121
3
Friday
LClark1102
by
Occasional Contributor
Friday

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!

Preview file
53 KB
0 Kudos
3 Replies
RyanUthoff
by MVP Regular Contributor
MVP Regular Contributor
Friday

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.

CodyPatterson
by MVP Regular Contributor
MVP Regular Contributor
yesterday

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:

CodyPatterson_0-1760355971907.png

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

0 Kudos
LClark1102
by
Occasional Contributor
yesterday

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