The mdbadmin user is a user defined in the backend database server to access the given MDB database. Occasionally, the mdbadmin's password needs to be reset on the given DB Server for a variety of reasons.
This article discusses where the mdbadmin user credentials are stored and how to encrypt for a new password configuration.
Release : 14.1 and higher
Component : CA Asset Portfolio Management
The mdbadmin password is located in the following places and uses two different methods to encrypt the database:
There are two methods to encrypt the mdbadmin password. Both methods are unique and apply to different aspects of the ITAM installation.
One will need the ITAM install media (ISO file or DVD)
- Mount the ISO or load the DVD for the ITAM install
- Assuming the install media is located on the F Drive, go to an Admin command prompt and cd to "F:\products\ITAM\Setups\CASM"
- Run the following command:
java -jar stringencrypter.jar [EXAMPLE PASSWORD]
Change "[EXAMPLE PASSWORD]" to be the password for the mdbadmin user in SQL Server
An output will present such as this:
F:\products\ITAM\Setups\CASM>java -jar stringencrypter.jar [EXAMPLE PASSWORD]
log4j:WARN No appenders could be found for logger (com.ca.crypto.impl.EncryptionUtil).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
ciphered text : XXXXXXXXX
- Copy the ciphered text string (ie: XXXXXXXXX)
Use the APM Password encryption utility, which can be downloaded in the files attached to this KB Article. File of interest is 1599158575305__RO72722.caz. Please review the following link for access to CAZIPXP.EXE to extract the CAZ zip file.
Additional content for the APM Password encryption utility is also available in the files attached to this KB Article. File of interest is 1599158591276__RO72722.txt