The connection property set was missing a required property or the property value was unrecognized. Bad login user. ArcGIS Datastore validation fails after upgrade

Error Message

After validating ArcGIS Data Store, an exclamation mark appears and, the following error is returned in the ArcGIS Server logs:

Error:   
The connection property set was missing a required property or the property value was unrecognized. Bad Log in user Datastore validation Fails after upgrade to 10.x.

Error:   
Type=warning, code =”110787” source “Data Store” process = “21232” thread = “1” methodName = “” machine “x" user= “” elapse = “” requestID = “” > Failed to create index on ‘{0}’ org.postgres.util.PSQLException: FATAL : no pg_hba.config entry for host “127.0.0.1”, user “hsu_tf4q2”, database “db_46pwc”, SSL off </msge> 

Cause

ArcGIS Server is configured using a domain name service (DNS) name instead of a fully qualified domain name (FQDN). Refer to ArcGIS Enterprise: Domain name service and fully qualified domain name requirements for more information.

Solution or Workaround

1. Unregister the data store. On the machine, run the Windows Command Prompt as an administrator.
2. Navigate to the ArcGIS Data Store utilities folder using the following command:

cd Program Files\ArcGIS\DataStore\tools

3. Run the 'unregisterdatastore' command utility to unregister the relational data store using the following command:

 unregisterdatastore.bat –stores relational –prompt yes

4. Navigate to the Data Store Configuration Wizard for the primary ArcGIS Server machine, and re-register the primary Data Store using the fully qualified domain name of the machine. The following is a sample of a fully qualified domain name URL:

<portal>.<domain>.com

5. After changing the domain name, validate ArcGIS Data Store. Refer to How To: Validate ArcGIS Data Store for steps to do this.