How do I point a IT Asset Manager 12.6 application at a different database?

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

I would like to point a IT Asset Manager 12.6 application at a different database.

How do I do that?

Answer:

Asset Manger must follow the below steps to change the APM application to point to another database server and\or database -Note: These are steps for SQL Server only.

These changes are NOT reflected in the system configuration screen in the APM UI.

Below are the steps to point the APM 12.6 installation to a new sql server mdb.

  1. Change the sql server user id/ password and the host name in all the ca.common.data.dll.config files.

    <!--Setting Login Information for DB-->

    <add key="UserID" value="sa" />

    <add key="Password" value="DZSHmQm6tSs=" />

    **Note: The SA password value needs to be encrypted. You must use the SWCMPasswordUtility.zip 

    Unzip the SWCMPasswordUtility.zip file from the CA Software Compliance Cumulative fix. 
    (The latest cumulative fix can be found at https://support.ca.com/irj/portal/anonymous/phpsupcontent?contentID={DE7218A2-564D-4547-9E01-8500B597F932}

    <!--Update HostName for Sql Connections and ServiceName for Oracle Connections-->

    <add key="HostName" value="tcp:ITAMW3R2A125A,1433" /> 

    **Note: This is the hostname of the machine where the database is located. 

    Each of the following folders contains a ca.common.data.dll.config file. 
    As the ca.common.data.dll.config files are identical, modifications can be done to one file and then copied to all the below locations.

    \Program Files\CA\ITAM\Application Server\bin 

    \Program Files\CA\ITAM\Data Importer (if they are using DI) 

    \Program Files\CA\ITAM\Event Service 

    \Program Files\CA\ITAM\Export Service 

    \Program Files\CA\ITAM\Hardware Engine 

    \Program Files\CA\ITAM\LDAP Import Sync Service 

    \Program Files\CA\ITAM\Storage Manager Service\bin 

    \Program Files\CA\ITAM\WCF Service\bin 

    \Program Files\CA\ITAM\Web Server\bin

  2. Reset IIS on the web and application server. 

  3. Since the original installation settings are stored in a configuration database (cdb) on the application, you will need to disable the ITAM Central Configuration Agent and the ITAM Central Configuration Controller from Admin tools-> services on the application server. If they are not disabled, anytime an application server reboot or a field is changed in any of the nodes of the system configuration screen, this activates the Central Configuration Controller which will overwrite the manual changes to the ca.common.data.dll.configs

    Disabling the ITAM Central Configuration Agent and the ITAM Central Configuration Controller from Admin tools-> services on the application server will prevent the cdb information from being overwrote into the ca.common.data.dll.config files.

    Note: When the ITAM Central Configuration Controller and ITAM Central Configuration agent are disabled, you will get the below error when you click on the system configuration link of the Administrator tab.

    Server Error in '/ITAM' Application. 
    'APM Central Configuration Controller (CCC)' service is not running or cannot connect.