Problem
The credentials of the database administrator are no longer available. The corresponding password has been lost or is otherwise unknown, making it impossible to log in using the database administrator account. As a result, administrative operations at the database level can no longer be performed, which significantly limits the ability to maintain, manage, and further configure the environment.
Solution
Due to the implemented end-to-end encryption, it is not possible to reset or retrieve the database administrator’s password.
As a result, there are two possible courses of action:
Password reset by an authorized user
If there is a user who has the appropriate permissions on the database administrator account, this user can reset the database administrator’s password.
Rebuilding the database as a last resort
If no appropriately authorized user exists, the only remaining option is to rebuild the database. In this case, a new database with a new database administrator must be created. Subsequently, the organizational units as well as the roles and permission model need to be reconfigured. The existing data must then be manually transferred to the new database via export/import.