Bad login user while Registering Data Stores

Question

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.

register data stores.png

Zminazim · Answer

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

VinceAngelo · Answer

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

SteveSawyer1 · Answer

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