idea2022.1 连sql server_dbms: case sensitivity: plain=mixed, delimited=exa

作者：IT小白 | 2024-04-07 22:54:16

踩

dbms: case sensitivity: plain=mixed, delimited=exact driver: (ver. , jdbc) e

报错：[08S01] 驱动程序无法通过使用安全套接字层(SSL)加密与 SQL Server 建立安全连接。错误:“The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]”。 ClientConnectionId:272392ee-1272-4622-928d-f8e0f9e1a335
The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12].

解决办法：修改文件C:\Program Files\JetBrains\IntelliJ IDEA 2022.1\jbr\conf\security\java.security

将：jdk.tls.disabledAlgorithms 中的TLSv1,3DES_EDE_CBC删除

测试数据库连接

DBMS: Microsoft SQL Server (ver. 10.50.1600)
Case sensitivity: plain=mixed, delimited=mixed
Driver: Microsoft JDBC Driver 10.2 for SQL Server (ver. 10.2.0.0, JDBC4.2)
Ping: 51 ms
SSL: no

TLSv1 was negotiated. Please update server and client to use TLSv1.2 at minimum.

解决办法：idea中Project Structure中的SDKs选jdk18,

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/IT小白/article/detail/381165