datagrip链接sql server2005报错
错误信息
第一次报
DBMS: Microsoft SQL Server (no ver.)
Case sensitivity: plain=mixed, delimited=exact
[08S01] 驱动程序无法通过使用安全套接字层(SSL)加密与 SQL Server 建立安全连接。错误:“The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]”。 ClientConnectionId:845485af-bc0a-4a1c-8d58-f80c0cc9282c
The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]
The following required algorithms might be disabled: SSLv3, TLSv1, TLSv1.1, RC4, DES, MD5withRSA, DH keySize < 1024, EC keySize < 224, 3DES_EDE_CBC, anon, NULL. Edit the list of disabled algorithms to include required algorithms. You can try to enable TLSv1 or TLSv1.1 first.
允许TLS1之后报错如下
DBMS: Microsoft SQL Server (ver. 10.50.1600)
Case sensitivity: plain=mixed, delimited=mixed
Driver: Microsoft JDBC Driver 12.2 for SQL Server (ver. 12.2.0.0, JDBC4.2)
Ping: 20 ms
SSL: no
TLSv1 was negotiated. Please update server and client to use TLSv1.2 at minimum.
最后只需要降低sql server jar 包版本即可
参考
https://blog.csdn.net/2301_78464877/article/details/139197710