Not Registered Database ArcGIS Server

[UğurcanGül]

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

[George_Thompson]

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-postgres...

[UğurcanGül]

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.

[George_Thompson]

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?

[UğurcanGül]

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

[George_Thompson]

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.

[UğurcanGül]

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

[George_Thompson · Accepted solution]

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...

[UğurcanGül]

Thanks, solved 🙂