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.
CA Asset Portfolio Management 14.1 and higher
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=[EXAMPLE PASSWORD]
sql2005.host=[EXAMPLE SQL SERVER]
dbtype=sql2005
sql2005.loginid=mdbadmin
sql2005.databaseName=mdb
itamwebserviceurl=http\://[EXAMPLE-ITAM-SERVER]\: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 XXXXXX== should read XXXXXX\=\=