topic Re: Bad login user while Registering Data Stores in ArcGIS Enterprise Questions

Bad login user while Registering Data Stores

CarlosGarcia_II — Thu, 24 Apr 2014 20:12:44 GMT

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.

Re: Bad login user while Registering Data Stores

tKasiaTuszynska — Wed, 09 Jul 2014 23:39:27 GMT

Carlos,

a bad log in user error from postgres means that you were not passing in a correct password or that postgres was not setup to allow connections from your ip address, by changing the authentication method in pg_hba. conf from md5 to trust, you told postgres not to check your password. Which suggests that the bad login error was comming from passing in a wrong password.

Re: Bad login user while Registering Data Stores

VinceAngelo — Thu, 10 Jul 2014 12:50:44 GMT

The "trust" setting is an opportunity for a fairly comprehensive denial-of-service attack

(unintentional or otherwise) to edit or delete all your data. I strongly suggest that you

protect your data as much as you value it, by using "md5" and a password.

- V

Re: Bad login user while Registering Data Stores

SteveSawyer1 — Wed, 19 Sep 2018 15:55:48 GMT

Vince,

I am seeing this same error in ArcGIS 10.6.1 Enterprise using IWA login and wish to resolve this either on the IT side of the house or in the postgres side. Please advise me on a solution pathway.

Regards,

Steve Sawyer

Re: Bad login user while Registering Data Stores

VinceAngelo — Wed, 19 Sep 2018 19:37:21 GMT

I have no advice for working with IWA.

I suggest you ask a new question, with details of the steps you are using and the error you have received.

- V

Re: Bad login user while Registering Data Stores

Zminazim — Sat, 17 Nov 2018 12:54:46 GMT

he ArcGIS Server service in Windows runs as a task, which has a user associated with it. Does the user that AGS is running as have access to SQL Server? When a data source is published with OS Authentication, then ArcGIS Server would be using it's OS authentication, not the authentication of the user that is publishing it. This is why the database user (arcgis_db) works, but the Windows user does not work. Share

Lucky Patcher 9Apps VidMate