监控SQLServer数据库报如下错误
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 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:cd11de43-2e1d-479b-924e-6cbdb10c3ec3".
如果我们在监控SQLServer出现以上错误提示
解决方法如下:
我们可以将JDK的版本升级到JDK11即可
如果不想升级server主机的JDK,我们可以使用
wgcloud-server-backup
来监控这个SQLServer数据库,然后把wgcloud-server-backup的主机JDK升级到JDK11
这样就可以了
其他说明:
监控SQLServer数据库报错
The server selected protocol version TLS10 is not accepted by client preferences [TLS12]
如何处理
监控SQLServer数据库报错
"encrypt" property is set to "true" and "trustServerCertificate" property is set to "false"
如何处理