While Installing APM 14.1 receive message the connection to host has failed on SQL screen.

Article Id: 74880

Status: Published

Updated On: 02-05-2018 04:51

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:

I am installing IT Asset Manager 14.1. I receive a message "the TCP/IP connection to host has failed. Please check the server name and credentials" on SQL screen.

The installation is on Windows 2016 with Java 1.6.

Environment:

Release:
Component: ARGIS

Resolution:

Open the registry. Go to the following key:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\KeyExchangeAlgorithms\Diffie-Hellman]

Add a DWORD value called ServerMinKeyBitLength and set this to 00000200

This tells the server to accept a 512 bit key which is less than the 1024 used by the JRE in the installer.