DataGrip2023配置连接Mssqlserver、Mysql、Oracle若干问题解决方案_tlsv1 was negotiated. please update server and cli

作者：Gausst松鼠会 | 2024-06-10 17:53:38

踩

tlsv1 was negotiated. please update server and client to use tlsv1.2 at mini

1、Mssqlserver连接

本人连的是Sql2008，默认添加时，地址、端口、实例、账号、密码后，测试连接出现错误。

Use SSL：不要勾选

VM option：填写，"-Djdk.tls.disabledAlgorithms=SSLv3, RC4, DES, MD5withRSA, DH keySize < 1024, EC keySize < 224, 3DES_EDE_CBC, anon, NULL"

软件安装后默认了：12.2.0，测试连接提示错误：

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

解决方案：选ver.8.2.2则可。

2、Mysql连接

Driver选择Mysql，具体可以自行测试调整该驱动。

注意：

VM option：填写，"-Djdk.tls.disabledAlgorithms=SSLv3, TLSv1.1, RC4, DES, MD5withRSA, DH keySize < 1024, EC keySize < 224, 3DES_EDE_CBC, anon, NULL"

如果提示错误：

[08S01] Communications link failure

The last packet successfully received from the server was 222 milliseconds ago. The last packet sent successfully to the server was 207 milliseconds ago. No appropriate protocol (protocol is disabled or cipher suites are inappropriate).

则尝试在URL内增加?useSSL=false

3、Oracle连接

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