TCPIP connection to the host failed when using Asset Viewer or AMS

Products

• CA IT Asset Manager
• ASSET PORTFOLIO MGMT- SERVER
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

In CA Asset Portfolio Manager (APM), when selecting the asset viewer - owned information, or the asset viewer - discovered information link,  it errors with: TCPIP connection to the host failed. 

Environment

CA Asset Portfolio Management 14.1, any patch level

Cause

AMS.properties file is missing the connection information

Resolution

1. On the APM application server, stop the Apache Tomcat AMS service

2. Edit the AMS.properties file, typically, located on the APM application server, in this path: 
    C:\Program Files (x86)\CA\SharedComponents\AMS\Tomcat\webapps\AMS\WEB-INF\classes

3. Locate and update the following entries with your specific SQL Server database and APM web server connection information: 

   sql2005.port=1433 
   sql2005.password=rpVTWUXCBNM 
   sql2005.host=MySQLServerHostName 
   dbtype=sql2005 
   sql2005.loginid=mdbadmin 
   sql2005.databaseName=mdb

   itamwebserviceurl=http\://APMWEB\:80/ITAMService/Service.asmx   <-- this is the correct syntax

4. Close the APM web browser, start the Apache Tomcat AMS service and retest the 'asset viewer - owned information' link. 

Additional Information

The passwords in the AMS.properties file are encrypted.  To verify an encrypted password, download the APM password encryption tool from this URL:  DB Password Encryption Information

Note: The AMS.properties file requires a backslash character (\) before any colon (:) or equals (=) symbols in the file. 

Examples:  the URL http:// should read http\://

an encrypted password, like rpD55YtuVxx9OPL== should read rpD55YtuVxx9OPL\=\=