topic The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ] in ArcGIS Enterprise Questions

The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ]

RedaAli — Thu, 30 Mar 2023 09:28:20 GMT

Hi ,

When registering sql server database connection as datastore on arcgis server site an error message

"The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ]"

Re: The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ]

ChrisUnderwood — Thu, 30 Mar 2023 10:14:54 GMT

What version of SQL Server are you trying to connect to ? Please check that you have an appropriate SQL Server client installed on your ArcGIS Server machine, eg Microsoft ODBC Driver 17 ?

https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-sqlserver.htm#ESRI_SECTION1_B75DB4BEF4BF40348621F378FB8F9FD8

Re: The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ]

RedaAli — Thu, 30 Mar 2023 10:25:52 GMT

Sqlserver 2019
Yes I already have installed ODBC Driver 17 for sqlserver

Re: The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ]

ChrisUnderwood — Thu, 30 Mar 2023 10:53:59 GMT

Are you able to connect to your database using that driver directly ? There are some notes on how to test that in this blog, section "Test with ODBC Data Source".

https://weblogs.asp.net/dixin/easy-ways-to-test-sql-server-sql-azure-connection

Make sure you use exactly the same server name format & user name etc as you have done in your Catalog Database Connection. You are looking for Test Data Source to show Tests Completed Successfully.

Re: The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ]

RedaAli — Thu, 30 Mar 2023 11:53:30 GMT

Thanks for your clarifications

Yes I can and the test completed successfully

But still I have the issue to register the connection to ArcGIS server Site

Re: The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ]

ChrisUnderwood — Thu, 30 Mar 2023 13:27:44 GMT

Are you able to log on to your ArcGIS Server machine as the ArcGIS Server Account, ie the Log On As user for your ArcGIS Server service ? If so, please do that and repeat the ODBC Data Source test.

Re: The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ]

TonyContreras_Frisco_TX — Fri, 31 Mar 2023 14:03:05 GMT

@RedaAli what values are you using for the connection info? Not the exact values, to protect security. Are you typing them in or importing an sde connection file?

Re: The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ]

RedaAli — Wed, 05 Apr 2023 08:40:09 GMT

I'm able to log in to the ArcGIS Server machine with the ArcGIS server Account
but test failed with ODBC

Re: The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ]

RedaAli — Wed, 05 Apr 2023 08:41:22 GMT

I can connect with ArcGIS pro
Importing the connection also tried typing

Re: The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ]

ChrisUnderwood — Wed, 05 Apr 2023 09:05:48 GMT

OK, so the problem is that the Windows user that acts as your ArcGIS Server Account cannot make a connection to your SQL Server database.

Did your failing ODBC test use Windows Authentication or SQL Server Authentication ?

Re: The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ]

RedaAli — Wed, 05 Apr 2023 09:24:11 GMT

failed with both Authentication

Re: The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ]

ChrisUnderwood — Wed, 05 Apr 2023 09:41:32 GMT

It could be that your ArcGIS Server machine has no access to your Database machine, eg through a Firewall ? Or your SQL Server database needs to allow connections from your ArcGIS Server machine ? Or your Windows user needs elevated privileges to run the ODBC 17 client ?

Might be time to ask your IT people about this. Essentially your Windows user cannot use Microsoft's ODBC tool, to connect to your SQL Server database.

Re: The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ]

Ian_Ice — Mon, 21 Aug 2023 16:47:41 GMT

I just solved this in my situation. I had this exact error when trying to register a database in our Development ArcGIS Enterprise System. One virtual machine has the SQL Server databases (MSSQL Server 2019) and another virtual machine has a single machine deployment of ArcGIS Enterprise. I go to register a database in the datastore on the Portal's hosting server and no bueno, I get the aforementioned error. I made sure the windows user running the AGS service had full permissions to everything and still......no bueno.

Solution - Although "Allow Remote Connections" was enabled in the SQL Server database properties in SSMS, TCP/IP protocols were disabled in the SQL Server Configurations. See attachment. Setting this to "enabled" and allowing the port (1433) across the firewall as an inbound rule solved the problem for me. See this link: https://www.apesoftware.com/calibration-control/help/sql-remote-connections. Hope this helps!!

Re: The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ]

ChrisGoodman2 — Thu, 22 Feb 2024 02:28:49 GMT

I had the same error when registering ArcGIS Datastore. I could register the datastore on the ArcGis Server, and the server could see it listed, but clicking Validate would fail with

"The connection property set was missing a required property or the property value was unrecognized. Invalid connection property.[ ]"

The root cause was that server could not contact datastore on port 6443.

See:

https://enterprise.arcgis.com/en/data-store/latest/install/windows/ports-used-by-arcgis-data-store.htm

Re: The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ]

Ian_Ice — Mon, 03 Feb 2025 21:28:06 GMT

Hello again! The error strikes again in a new 11.4 enterprise deployment and it was not due to the TCP/IP protocols in SQL this time (See other resolution above). This time, the error was due the ArcGIS Server machine not being able to communicate with the SQL Server machine via an alias. Our database (.sde) files use our sql machine's alias in the connection properties. This is to streamline migrations. I noticed I couldn't get to any fileshares on the sql machine from the arcgis server machine unless I used the full machine name. I reached out to IT and they changed the DNS search order on the ArcGIS Server machine so the alias now has .domain.org. This also could've been resolved by creating a new .sde connection using the machine name or by using alias.domain.org.

Re: The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ]

BlakeTerhune — Thu, 23 Oct 2025 22:53:53 GMT

Thank you, @Ian_Ice! ❤️

I used the fully qualified domain name for the server hosting the SQL Server database when creating the .sde connection file. Then, using that as the source for the layers in my map is what finally worked for me when trying to publish a service from Pro 3.5.4 to Portal 11.5.

Re: The connection property set was missing a required property or the property value was unrecognized. Failure to access the DBMS server[ ]

jorisfrenkel — Thu, 12 Mar 2026 15:56:46 GMT

I had this problem too (same error message when registering the database as Data Store). The cause was the limit in SQL Server on the length of the windows account name. Domain name +"\" + account name can be max 31 characters.