连接sqlserver 报错

Viewed 47

已经设置了encrypt=false;trustServerCertificate=false,依然报错
doris version:2.0.13
sqlserver:2012

1105 - errCode = 2, detailMessage = Test FE Connection to JDBC Failed: Can not connect to jdbc due to error: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]". ClientConnectionId:67c5bf08-d91e-4eef-af63-75888868c534, Catalog name: sqlserver
CREATE CATALOG sqlserver PROPERTIES (
    "type"="jdbc",
    "user"="test",
    "password"="123455",
    "jdbc_url" = "jdbc:sqlserver://192.168.100.2:1433;databaseName=testdb;encrypt=false;trustServerCertificate=false",
    "driver_url" = "mssql-jdbc-12.6.3.jre8.jar",
    "driver_class" = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
)

更换版本还是一样的错误

mssql-jdbc-11.2.3.jre8.jar 
mssql-jdbc-9.4.1.jre8.jar
2 Answers

只设置一个encrypt=false试试

没有变化一样的报错