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

Not Registered Database ArcGIS Server

UğurcanGül — Thu, 26 Jan 2023 05:42:11 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.

"A required property is missing or the property value is not recognized in the connection property setting. Invalid link attribute.[ ]" The missing parameter encrypted password appears.

Portal version 11.0

using db postgresql

arcgis pro version 3.0

Re: Not Registered Database ArcGIS Server

George_Thompson — Thu, 26 Jan 2023 11:35:17 GMT

Is Server and PostgreSQL on the same machine?

I noticed that you put "localhost" in the connection properties. If they are on different machines, you will need to make sure to update the pg_hba.config file to allow access: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-postgresql/configure-postgresql-accept-connections.htm

Re: Not Registered Database ArcGIS Server

UğurcanGül — Wed, 01 Feb 2023 11:25:55 GMT

Yes, all deployment(portal,ds,server and psql) on the same machine. I made all the necessary changes in pg_hba.config file. But Im getting still same error.

Re: Not Registered Database ArcGIS Server

George_Thompson — Wed, 01 Feb 2023 12:20:29 GMT

Is the password saved in the connection file that was imported for the registration?

What is the version of PostgreSQL being used?

What is the version of the Enterprise Geodatabase?

Re: Not Registered Database ArcGIS Server

UğurcanGül — Wed, 01 Feb 2023 12:23:49 GMT

The password is not registered in the attributes of the sde file imported for registration. Postgresql 12 is in enterprise geodatabase version 11.

Re: Not Registered Database ArcGIS Server

George_Thompson — Wed, 01 Feb 2023 13:10:59 GMT

Ah, ok. You may need to save the credentials in the "<name>.sde" file then import it.

You can create a local version of the .sde file if you are worried about security.

Re: Not Registered Database ArcGIS Server

UğurcanGül — Wed, 01 Feb 2023 13:13:52 GMT

how do i import credentials(only password-encrypted attribute) to sde file? I have no problem with security.

Re: Not Registered Database ArcGIS Server

George_Thompson — Wed, 01 Feb 2023 13:26:32 GMT

In ArcGIS Pro you need to create a Database connection. When you do this, make sure the "Save Credentials" option is checked. You then can use that .sde file to import as a DataStore.

look at Step 7: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-postgresql/connect-postgresql.htm#ESRI_SECTION1_901CC06ED9844E239D1F95DF6736EAC3

Re: Not Registered Database ArcGIS Server

UğurcanGül — Wed, 01 Feb 2023 13:36:53 GMT

Thanks, solved 🙂