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

[RedaAli]

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[ ]"

[TonyContreras_Frisco_TX]

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

[RedaAli]

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

[Ian_Ice]

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

[ChrisGoodman2]

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

[Ian_Ice]

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.