search cancel

The TCP/IP connection to the host has failed error

book

Article ID: 120927

calendar_today

Updated On:

Products

CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

How to bypass error attempting to install the mdb on 2016 SQL database server with 14.1 product version

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

Environment

Service Management 14.1
SQL 2016

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