How do I configure APM 12.9 to use a different sql server database? We are upgrading our SQL server to 2008, on a different server.

book

Article ID: 36975

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Introduction:

This document provides instruction steps to re-point an existing CA Asset Portfolio Management (APM) 12.9 installation to a new database. 

Instructions:  


1. Backup and restore the database (typically named 'mdb') from the original SQL Server to a new SQL Server machine. 
    If unfamiliar with SQL backup and restore, consult your DBA or SQL Server documentation for detailed instructions. 

2. On the APM application server, stop all of the CA Asset Portfolio Manager services 

3. On the APM application server, edit the \Program Files (x86)\CA\ITAM\Application Server\bin\ CA.Common.LoadConfigurationAttributes.dll.config file.
    Update the following entries to match your new SQL Server installation: 

    <add key="SqlServerVersion" value="MS SQL Server 2012"/>            (or "MS SQL Server 2008") 
    <add key="UserID" value="sa"/> 
    <add key="Password" value="rpSXWUM925Aw=XCB"/> 
    <add key="HostName" value="tcp:MySQLServerHostName,1433"/> (or tcp:MySQLServerHost\Instance,port#) 
    <!--Only need for Sql--> 
    <add key="DatabaseName" value="mdb"/> 
    <add key="DatabaseOwner" value="dbo"/> 

Note: 
         a. the UserID should exist in the new SQL Server installation, with dbowner rights to the mdb database. If it does not, create this user. 
         b. the password is encrypted. To encrypt passwords, download the password encryption utility (RO72722) from here: 
             http://www.ca.com/us/support/ca-support-online/product-content/recommended-reading/technical-document-index/ca-asset-portfolio-management-solutions-and-patches.aspx?intcmp=searchresultclick&resultnum=1   and run the encryption utility to create an encrypted password. 


4. Close and save the CA.Common.LoadConfigurationAttributes.dll.config file. 

5. Copy the CA.Common.LoadConfigurationAttributes.dll.config file and replace it in the following directories: 
\Program Files (x86)\CA\ITAM\Data Importer 
\Program Files (x86)\CA\ITAM\Data Importer Engine 
\Program Files (x86)\CA\ITAM\Export Service 
\Program Files (x86)\CA\ITAM\Event Service 
\Program Files (x86)\CA\ITAM\Hardware Engine 
\Program Files (x86)\CA\ITAM\Import Driver 
\Program Files (x86)\CA\ITAM\Import Processor 
\Program Files (x86)\CA\ITAM\Import Service\bin 
\Program Files (x86)\CA\ITAM\LDAP Import Sync Service 
\Program Files (x86)\CA\ITAM\Registration Service 
\Program Files (x86)\CA\ITAM\Storage Manager Service\bin 
\Program Files (x86)\CA\ITAM\WCF Service\bin 

6. Log onto the APM web server, and also replace the CA.Common.LoadConfigurationAttributes.dll.config file in this directory:
    \Program Files (x86)\CA\ITAM\Web Server\bin 


7. Launch SQL Server Management studio, and run this query against the new mdb: 
    select * from al_cdb_configurationparameters where componentkey = 'Database' 

    Review the data in the configvalue column, where configkey = DatabaseOwner, DbInstance, DbLogin, DbNameTxt, DbPassword, DbTcpIpPort, HostName and
    SqlServerVersionddl. (DbInstance is blank, if you are using the default instance.  
    If you are using a named instance, then update this configvalue with the instance name. 

    Run sql updates to update the configvalues, as appropriate for your installation. 

    Here is an example query to update just the HostName row: 
    update al_cdb_configurationparameters set configvalue = 'MyNewSQLServerHost' where configkey = 'HostName' 

    Run additional updates where configkey = DatabaseOwner, DbInstance, DbLogin, DbNameTxt, DbPassword, DbTcpIpPort

8. From a command prompt, perform an IISRESET on BOTH the APM web and APM application servers 

9. Login to the APM application, navigate to Administration -> System Configuration -> Database, and verify the entries. 

10. Start the CA Asset Portfolio Management services. 




Environment

Release: UAPMAC990JPP-12.9-Asset Portfolio Management-Asset Configuration
Component: