AMS database password change

Products

• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

As part of best practices for high Security, you would use encrypted passwords.  With respect to the Asset Viewer feature of CA Service Desk Manager, it may be necessary to make some changes to the situation that exists after an initial installation or upgrade of CA Service Desk Manager.

For the SERVICEDESK Tomcat servlet instance,  there is a file called "AMS.properties" that is used by the Asset Viewer feature of CA Service Desk Manager. 

The location of the file is $NX_ROOT\bopcfg\www\CATALINA_BASE\webapps\AMS\WEB-INF\classes (where $NX_ROOT refers to the base CA Service Desk Manager installation directory; for example, "C:\Program Files (x86)\CA\Service Desk Manager").

Environment

CA Service Desk Manager 14.1 on Windows

Resolution

Steps to encrypt the password on CA Service Desk Manager for Windows environment are as follows:

1. View the Configuration Item Detail of a Configuration Item (CI).
2. Click on "Asset Viewer" to verify that the feature works.
3. Make a backup of the file named "AMS .properties" that exists in the "$NX_ROOT\bopcfg\www\CATALINA_BASE\webapps\AMS\WEB-INF\classes" directory/folder.
4. Open the file and remove all passwords (clear text and encrypted ones).
5. Open a command prompt window.
6. Navigate to $NX_ROOT\CA\Service Desk Manager\bopcfg\www\CATALINA_BASE\webapps\AMS
7. Run the following command, specifying valid values from the environment for [EXAMPLE HOSTNAME] and [EXAMPLE PASSWORD]:
   java -classpath WEB-INF/lib/iijdbc.jar;WEB-INF/lib/log4j-1.2.17.jar;WEB-INF/classes;WEB-INF/com/ca/unicenter/uams/config com.ca.unicenter.uams.config.AMSConfig host=[EXAMPLE HOSTNAME] dbtype=sql2005 port=1433 databaseName=mdb loginid=mdbadmin password=[EXAMPLE MDBADMIN PASSWORD]
   Note: If the "java" command is not recognized, set JAVA_HOME appropriately and add the value of JAVA_HOME to the PATH variable.
8. Login to ServiceDesk via the web browser interfaced.
9. View the Configuration Item Detail of a Configuration Item (CI).
10. Click on "Asset Viewer" to verify that the feature still works.