SQL Server 2012 Encrypted connection issue on Windows Server 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-362499%22%20slang%3D%22en-US%22%3ESQL%20Server%202012%20Encrypted%20connection%20issue%20on%20Windows%20Server%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-362499%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20installed%20SQL%20Server%202012%20on%20Windows%20Server%202016%20DataCenter%2C%20when%20trying%20to%20use%20EncryptionMethod%3DSSL%20while%20creating%20the%20DataSource%20we%20are%20getting%20the%20below%20error%3A%22Connection%20verification%20failed%20for%20data%20source%3A%20testCDX%3CBR%20%2F%3Ejava.sql.SQLNonTransientConnectionException%3A%20%5BMacromedia%5D%5BSQLServer%20JDBC%20Driver%5DSSL%20handshake%20failed%3A%20sun.security.validator.ValidatorException%3A%20PKIX%20path%20building%20failed%3A%20java.security.cert.CertPathBuilderException%3A%20Could%20not%20build%20a%20validated%20path.%3CBR%20%2F%3EThe%20root%20cause%20was%20that%3A%20java.sql.SQLNonTransientConnectionException%3A%20%5BMacromedia%5D%5BSQLServer%20JDBC%20Driver%5DSSL%20handshake%20failed%3A%20sun.security.validator.ValidatorException%3A%20PKIX%20path%20building%20failed%3A%20java.security.cert.CertPathBuilderException%3A%20Could%20not%20build%20a%20validated%20path.%22%3C%2FP%3E%3CP%3EKindly%20note%20that%20the%20issue%20is%20occurring%20only%20on%20WS2016%2C%20we%20have%20the%20same%20implementation%20done%20on%20WS2012%20and%20everything%20works%20fine.%3C%2FP%3E%3CP%3EWould%20you%20please%20advise%20how%20can%20we%20solve%20the%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

We have installed SQL Server 2012 on Windows Server 2016 DataCenter, when trying to use EncryptionMethod=SSL while creating the DataSource we are getting the below error:"Connection verification failed for data source: testCDX
java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]SSL handshake failed: sun.security.validator.ValidatorException: PKIX path building failed: java.security.cert.CertPathBuilderException: Could not build a validated path.
The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]SSL handshake failed: sun.security.validator.ValidatorException: PKIX path building failed: java.security.cert.CertPathBuilderException: Could not build a validated path."

Kindly note that the issue is occurring only on WS2016, we have the same implementation done on WS2012 and everything works fine.

Would you please advise how can we solve the issue?

0 Replies