AnsweredAssumed Answered

Error when registering PostgreSQL database with ArcGIS Server

Question asked by jiels_sdfe on Sep 10, 2019
Latest reply on Sep 12, 2019 by pan_gis

I am trying to register a PostgreSQL database with our ArcGIS Server v. 10.7. I get the following error message: "The connection property set was missing a required property or the property value was unrecognized. Instance not available on the server".

 

I can connect to the database fine from ArcCatalog on client machines, but I also get an error when I try and connect via ArcCatalog on the server: "Connection timed out. Is the server running on hose <postgresql db servername> and accepting TCP/IP connections on port 5432? SQLSTATE="

 

I have updated the pg_hba.conf to include the IP address of both the arcgis server and also the portal machine that has the web adaptor installed (our server is federated with Portal). I also confirmed that the postgreSQL login user that I am connecting with has the correct privileges and is the owner of a schema in the database, as per the ESRI documentation.

 

What am I missing that is preventing me from registering the database with the arcgis server?

Outcomes