驱动程序无法通过使用安全套接字层(SSL)加密与 SQL Server 建立安全连接。

问题描述

在连接SQLServer数据库的时候报错：
驱动程序无法通过使用安全套接字层(SSL)加密与 SQL Server 建立安全连接。错误:“PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target”。 ClientConnectionId:e8905ebb-d67b-40fd-9ca9-a246b6858ff6

Caused by:com.microsoft.sqlserver.jdbc.SQLServerException: 驱动程序无法通过使用安全套接字层(SSL)加密与 SQLServer 建立安全连接。错误:“PKIX path building failed:sun.security.provider.certpath.SunCertPathBuilderException: unable tofind valid certification path torequested target”。 ClientConnectionId:e8905ebb-d67b-40fd-9ca9-a246b6858ff6
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3680)
    at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:2047)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:3204)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2833)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2671)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1640)
    at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:936)
    at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:118)
    at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:232)
    at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:112)
    at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1694)
    at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1789)
    at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:939)
    at com.baomidou.dynamic.datasource.creator.DruidDataSourceCreator.doCreateDataSource(DruidDataSourceCreator.java:85)...108 common frames omitted

解决方案：

在连接url后面添加encrypt=true;trustServerCertificate=true即可