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

book

Article ID: 74880

calendar_today

Updated On:

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.