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.
AMS.properties file is missing the connection information
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.
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\=\=