Update Database Connection After Password Change

Question

Hey all,

I have recently changed my password for a database connection. I am working in an ArcGIS Pro (3.0.3) project that uses this database connection and it asks for my credentials to the db every time I open the project. I will enter my credentials and ensure the "save username/password" option is selected. It still asks me for my password every time I open the project.

Has anyone encountered this before and know how to resolve this?

Thanks!

RafaelGil · Answer

Hey All,

I wanted to add a solution to this workflow when a database user password is changed, and the existing ArcGIS Pro maps open with all the data sources broken per layer. The key here is that the database credentials used to connect get stored per layer in each map. The connections are not dynamically referenced directly from the .sde file.

Solution: To avoid opening a map with broken paths (red exclamation marks), you can update data sources before opening your map:

------Update data sources
https://pro.arcgis.com/en/pro-app/3.4/help/projects/update-data-sources.htm
-----

For multiple maps?? You can create a python script to automate this process and fix all your maps after a database user password change.

Good Luck!

AlexanderDanielPratama · Answer

Yes, it happens to me. If my memory serves me right, you must create the new SDE file (add new connection) with the latest username-password and check save the username-password box. Remove your old SDE file, then rename your new SDE file similar to your old one. Then, save your arcgis project, reopen it again. Usually it works for me.

Hope it helps you,

Cheers