sql-server - IBM WebSphere Application 服务器的连接问题

Question

• 通过 SSMS 与 sa 用户的数据库连接按预期工作。o SQL Server 正在侦听端口 1433 o SSL 加密在 SQL Server 级别为 FALSE

尝试使用以下罐子

mssql-jdbc-8.2.2.jre8- , 
mssql-jdbc-8.2.2.jre11.jar, 
mssql-jdbc-8.2.2.jre13.jar.

错误：

The test connection operation failed for data source *xxxxx(DB instance)* on server dmgr 
at node AptraCellManager01 with the following exception: j**ava.sql.SQLException: 
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:7f6078da-828e-4ac2-9b49-96ee6a8bc177". DSRA0010E: SQL State = 08S01, Error Code =0.
View JVM logs for further details.**

标签： sql-serverwebsphere

Answer 1

通过在 dmgr jvm 自定义属性中添加 com.ibm.jsse2.overrideDefaultTLS =true 解决了连接问题

https://www.ibm.com/support/pages/how-get-datasource-websphere-85x-working-sql-server-using-tlsv12