In Portal for ArcGIS, end users may experience the following behavior:
Validating the ArcGIS relational datastore fails from ArcGIS Server Manager. Inspecting the ArcGIS Server Manager log files reveal the following error:
The connection property set was missing a required property or the property value was unrecognized. Bad login user.
Viewing the PostgreSQL datastore logs files located here: arcgisdatastore\logs\machine\database reveals the following error:
FATAL: no pg_hba.conf entry for host "<new_ip_address>", user "<redacted>", database "<redacted">, SSL off
The error is normally due to the ArcGIS Server machine not having access to connect to the underlying PostgreSQL database configured with the ArcGIS relational datastore. This may happen if the ArcGIS Data Store is configured using a different account than ArcGIS Server or sometimes after an upgrade is performed.
One way to resolve the issue is to update the pg_hba.conf PostgreSQL configuration file on the ArcGIS relational datastore machines to allow connections from the ArcGIS Server machine(s).
The following steps summarize what must be done to allow connections from the ArcGIS Server machine to the PostgreSQL database located on the ArcGIS relational datastore machine. The entries you place in the pg_hba.conf will vary depending on security policies and configurations at your site.
host db_vcokl sde 127.0.0.1/32 scram-sha-256