Securing connection between SQL Server and Debezium with TLS

Issue

• How to secure the connection between SQL Server and Debezium using TLS

• Debezium SQL Server connector failed to start with the following message:

  PUT /connectors/inventory-connector-sqlserver/config returned 400 (Bad
  Request): Connector configuration is invalid and contains the following
  1 error(s):
  
  Unable to connect. Check this and other connection properties. Error:
  "encrypt" property is set to "false" and "trustServerCertificate"
  property is set to "false" but the driver could not establish a secure
  connection to SQL Server by using Secure Sockets Layer (SSL) encryption:
  Error: PKIX path building failed:
  sun.security.provider.certpath.SunCertPathBuilderException: unable to
  find valid certification path to requested target.
  ClientConnectionId:b7838a36-65f5-42bd-a3c5-2a45gre6ea28
  
  You can also find the above list of errors at the endpoint
  `/connector-plugins/{connectorType}/config/validate`
  reason: ConnectRestException