Question

StreamSet with MS SQL connection Issues

  • 9 January 2024
  • 1 reply
  • 58 views

Hi The Top Contributors,

 

I have tried many connections on SQL with StreamSet but it is not workings

Remediation steps:

Make sure the connection properties have been properly set to allow SSL connections with the database. Check out the links below for more information on how to configure the SQL Server properties. - https://learn.microsoft.com/en-us/sql/connect/jdbc/connecting-with-ssl-encryption?view=sql-server-ver15#configuring-the-connection - https://learn.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver15

 

Technical details:

The SSL negotiation has failed and the driver found has not been able to initialize the Connection Pool: Failed to initialize pool: "encrypt" property is set to "true" 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:bb25f279-c50b-4d56-89be-d99c24a188ce - com.microsoft.sqlserver.jdbc.SQLServerException: "encrypt" property is set to "true" 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:bb25f279-c50b-4d56-89be-d99c24a188ce

 

com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: "encrypt" property is set to "true" 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:bb25f279-c50b-4d56-89be-d99c24a188ce

            at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:596)

            at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:582)

 

Can anyone help on this please?


1 reply

Userlevel 2

try adding  the below to the end of your connection string

 

;encrypt=true;

Reply