3624687 - Unable to establish a secure connection to MS SQL server database and SAP Event Stream Processor throws connection error

Below error occurs in esp_server.log while connecting to MS SQL Server without SAP Replication Server Option (RSO):

2025-05-16 14:58:40.695 | 23692 | container | [SP-3-100005] (276.157) sp(23147) Error opening connection to database. 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:xxx
2025-05-16 14:58:40.695 | 23692 | container | [SP-3-148011] (276.158) sp(23147) ConnectionWriter(PanoramaPaymentsout) connection reset error: 2025-05-16 14:58:40 DBOutput_Adapter::resetConnection - Error getting connection from service
- DBOutput_Adapter::resetConnection Adapter initialization failed
DBOutput_Adapter processParams call to resetConnection failed
Could not create connection for Service: xxx
DBOutput_Adapter::processParams - Error getting connection from service
- DBOutput_Adapter::processParams Adapter initialization failed
Error(s) encountered in startup parameters.  Adapter initialization failed 

Pre-requisites:

• TLS version on ESP server is up to date.
• service.xml file is properly configured:
  

  <Service Name="<service-name>" Type="DB">

           <Parameter Name="DriverLibrary">esp_db_jdbc_mssql_lib</Parameter>

           <Parameter Name="Host"><IP-Address></Parameter>

           <Parameter Name="Port"><port></Parameter>

           <Parameter Name="User"><username></Parameter>

           <Parameter Name="Password"><password></Parameter>

           <Parameter Name="Database"><db-name></Parameter>

           <Parameter Name="ConnectString">jdbc:sqlserver://<IP-Address>:<port>;databaseName=<db-name>;encrypt=false;trustServerCertificate=true</Parameter>

SAP Event Stream Processor

DH keypair, SSL, java.lang.RuntimeException , KBA , BC-SYB-ESP , Sybase ESP (Event Stream Processor) , Problem