MS Sql Server Connector SSL Connection failed

[Gopinath Varadarajan]

Hi,

Trying to connect to SQL Server , getting this error, please help.

{"error_code":400,"message":"Connector configuration is invalid and contains the following 1 error(s):\nUnable to connect. Check this and other connection properties. Error: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: \"SQL Server did not return a response. The connection has been closed. ClientConnectionId:595894cc-d7c7-4b6b-a433-b60e8ed933d1\".\nYou can also find the above list of errors at the endpoint `/connector-plugins/{connectorType}/config/validate`"}

Thanks,

Gopi

[Gopinath Varadarajan]

We are using java version "1.8.0_241"

Debezium Sql Connector 1.9.2 version

Java(TM) SE Runtime Environment (build 8.0.6.7 - pxa6480sr6fp7-20200312_01(SR6 FP7))
IBM J9 VM (build 2.9, JRE 1.8.0 Linux amd64-64-Bit Compressed References 20200219_440062 (JIT enabled, AOT enabled)
OpenJ9   - 3088245
OMR      - eb95a4d
IBM      - 83517b6)
JCL - 20200310_01 based on Oracle jdk8u241-b07

Thanks

[Jürgen Albersdorfer]

Please see my answer in https://groups.google.com/g/debezium/c/YkyXZxJGTKk/m/sPYZJoB9AQAJ - maybe it helps you too