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
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.
Open the registry. Go to the following key:

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.