The TCP/IP connection to the host has failed error

Document ID : KB000120927
Last Modified Date : 13/11/2018
Show Technical Document Details
Issue:
How to bypass error attempting to install the mdb on 2016 SQL database server with 14.1 product version
Environment:
Service Management 14.1
SQL 2016
Cause:
The Database version SQL 2016 is not supported for SM 14.1 application. 

 Error Message:
com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "java.lang.RuntimeException: Could not generate DH keypair". ClientConnectionId:c83c9588-8b68-4b4c-a346-f910f7427561
Resolution:
Extract ISO media to a root directory, if not done and follow below instructions as workaround

1. Open the java.security file under jre/lib/security of the extracted DVD 
2. Search for jdk.tls.disabledAlgorithms 
3. Set jdk.tls.disabledAlgorithms=DHE, ECDHE 
4. Save and rerun the installation setup with admin rights. 
 
Additional Information:
Note: Below is the document for swing box method: 

https://docops.ca.com/ca-service-management/14-1/en/implementing/implementing-ca-service-management-14-1/step-4-install-or-upgrade/implementing-ca-service-desk-manager/how-to-upgrade-ca-sdm/step-2-use-the-ca-sdm-migration-console/upgrade-ca-sdm-using-the-swing-box-method