In some organization, it requires database password rotation on a regular basis. After changing the schema passwords, follow these steps to implement the new password on LIMS server. In LIMS server, the encrypted schema passwords are stored in the following location:
Log into LIMS server and navigate to the above folder to access the dbuser.txt file.
Remove the encrypted password line (eg aes://xxxxxxxxxxxxx where xxxxxx is the encrypted password) and replace with new password in plain text. Save the dbuser.txt file.
From the Windows Start Menu, navigate to BIOVIA and right-click on ‘Initialize BIOVIA-LIMS’. Then select ‘Open File location’ and then right-click on ‘Initialize BIOVIA LIMS’. Select ‘Run as Administrator’. After the initialization is complete, check the ‘dbuser.txt’ for encryption of schema passwords.