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[ ]"
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
Sqlserver 2019 Yes I already have installed ODBC Driver 17 for sqlserver
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.
Thanks for your clarificationsYes I can and the test completed successfullyBut still I have the issue to register the connection to ArcGIS server Site
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.
@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?
I'm able to log in to the ArcGIS Server machine with the ArcGIS server Accountbut test failed with ODBC
I can connect with ArcGIS proImporting the connection also tried typing
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 ?
failed with both Authentication
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.
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!!
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:
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.
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.
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.
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
