Bad login user while Registering Data Stores

Discussion created by xenoranger on Apr 24, 2014
Latest reply on Nov 17, 2018 by zmirlinazim
This isn't a question, but we're posting a resolution for an issue.

While attempting to register a map as a service in ArcServer 10.1, we kept getting the message in this post's attachment.

So, we found that our:

  • GIS Services connection worked

  • SDE Connection worked

  • PG Client Libraries were properly installed on both Server and Desktop

  • All users were set to TRUST in pg_hba.conf

Both ArcMap and ArcCatalog would continue failing to register the data with our ArcGIS Server.

To resolve this, we opened the pg_hba.conf and updated the loopback addresses from MD5 (default) to Trust. Once this was done, we were able to register the data.

I'm guessing this may resolve the issue with other flavors of SQL besides Postgres.