How to update DB login information when the password has been changed in ITAM 12.9?

Document ID : KB000029415
Last Modified Date : 14/02/2018
Show Technical Document Details

In order to update DB login information in ITAM 12.9 please follow the below steps. Some of these steps can also be used when repointing the database to a different database server.

1- download the ITAM 12.9 password encryption tool (RO72722);
2- stop all ITAM services;
3- run the below SQL update statement:
update al_cdb_configurationparameters set configvalue = 'NEW ENCRYPTED PASSWORD' where configkey = 'DbPassword';
4- update the file CA.Common.LoadConfigurationAttributes.dll.config with the new password at these locations (you can update once and replace the other ones with the first updated file):

...\CA\ITAM\Application Server\bin
...\CA\ITAM\Data Importer
...\CA\ITAM\Data Importer Engine
...\CA\ITAM\Event Service
...\CA\ITAM\Export Service
...\CA\ITAM\Hardware Engine
...\CA\ITAM\Import Processor
...\CA\ITAM\Import Driver
...\CA\ITAM\Import Service\bin
...\CA\ITAM\LDAP Import Sync Service
...\CA\ITAM\Registration Service
...\CA\ITAM\Storage Manager Service\bin
...\CA\ITAM\WCF Service\bin
...\CA\ITAM\Web Server\bin

5- reset IIS and restart all ITAM services that you had previously stopped.