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

Document ID : KB000074880
Last Modified Date : 02/05/2018
Show Technical Document Details
Question:
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.
Answer:
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.