topic Re: Not Registered Database ArcGIS Server in ArcGIS Enterprise Questions

Not Registered Database ArcGIS Server

UğurcanGül — Mon, 07 Nov 2022 19:20:47 GMT

Hello,

I've created my sde database in ArcGIS Pro without any problems. When I import this in server manager>site>datastores, I get the attached error.

Portal version 10.9.0

using db postgresql

arcgis pro version 3.0

Re: Not Registered Database ArcGIS Server

ReeseFacendini — Mon, 07 Nov 2022 19:24:30 GMT

Is the PostgreSQL ODBC driver installed on the machine with ArcGIS Server?

Re: Not Registered Database ArcGIS Server

WellingtonAlves — Mon, 07 Nov 2022 19:26:23 GMT

I had the same error some weeks ago, try to replace the localhost to your IP Address. It worked here.

Re: Not Registered Database ArcGIS Server

UğurcanGül — Mon, 07 Nov 2022 19:34:47 GMT

Thanks for answer. I entered the instance location as IP. However, I got the same error again.

Re: Not Registered Database ArcGIS Server

UğurcanGül — Tue, 08 Nov 2022 11:12:47 GMT

I solved the problem as of now. No need to install odbc to use Postgresql. But if you want, you can install the odbc driver from the stack builder. But it has nothing to do with the solution. Solution;

I updated the trust fields to md5 in the password authentication section of the pg_hba.conf file located in the directory where you installed Postgresql (my path is C:/Program Files/PostgreSQL/12/data). Yes, after restarting my computer, the problem was solved.

Thanks.