search

alibaba / ali-dbhub

已迁移新仓库，此版本将不再维护
8.31k stars 1.29k forks source link

为什么SQL SERVER 连接不上啊说端口无效 #102

Closed CHANGUO closed 1 year ago

CHANGUO commented 1 year ago

image

Chat2DB-Pro commented 1 year ago

麻烦看下~.chat2db/logs下的日志

CHANGUO commented 1 year ago

麻烦看下~.chat2db/logs下的日志

2023-05-10 12:32:40.892 [http-nio-127.0.0.1-10824-exec-4] INFO c.a.d.s.w.a.a.BusinessExceptionHandler - proceed end:com.alibaba.dbhub.server.web.api.controller.data.source.DataSourceControllerpreConnect, result:{"errorCode":"端口号 1433/ 无效。","success":false}, cost:1 2023-05-10 12:32:41.069 [http-nio-127.0.0.1-10824-exec-5] INFO c.a.d.s.w.a.a.BusinessExceptionHandler - proceed begin:com.alibaba.dbhub.server.web.api.controller.data.source.DataSourceControllerpreConnect ,param:[{"alias":"@127.0.0.1","type":"SQLSERVER","url":"jdbc:sqlserver://127.0.0.1:1433/","user":"sa"}] 2023-05-10 12:32:41.069 [http-nio-127.0.0.1-10824-exec-5] INFO c.a.d.s.w.a.a.BusinessExceptionHandler - proceed end:com.alibaba.dbhub.server.web.api.controller.data.source.DataSourceControllerpreConnect, result:{"errorCode":"端口号 1433/ 无效。","success":false}, cost:0 2023-05-10 12:32:41.228 [http-nio-127.0.0.1-10824-exec-7] INFO c.a.d.s.w.a.a.BusinessExceptionHandler - proceed begin:com.alibaba.dbhub.server.web.api.controller.data.source.DataSourceControllerpreConnect ,param:[{"alias":"@127.0.0.1","type":"SQLSERVER","url":"jdbc:sqlserver://127.0.0.1:1433/","user":"sa"}] 2023-05-10 12:32:41.229 [http-nio-127.0.0.1-10824-exec-7] INFO c.a.d.s.w.a.a.BusinessExceptionHandler - proceed end:com.alibaba.dbhub.server.web.api.controller.data.source.DataSourceControllerpreConnect, result:{"errorCode":"端口号 1433/ 无效。","success":false}, cost:1 这个应用是不是类似这个 需要信任服务器？ image

wholon commented 1 year ago

遇到同样的问题

Chat2DB-Pro commented 1 year ago

1.0.3已经修复这个问题

CHANGUO commented 1 year ago

engfei-jpf closed this as completed May 17, 2023

image 还是有一个问题。。。这个肯定和服务器没关系的

Chat2DB-Pro commented 1 year ago

啊，我看了下这个是因为安全协议的问题，安全协议新的JDK不支持了，你们系统连接sqlserver使用的java吗？java多少版本?我们要去改jre才能解决这个问题：https://stackoverflow.com/questions/67246010/error-message-the-server-selected-protocol-version-tls10-is-not-accepted-by-cli

CHANGUO commented 1 year ago

啊，我看了下这个是因为安全协议的问题，安全协议新的JDK不支持了，你们系统连接sqlserver使用的java吗？java多少版本?我们要去改jre才能解决这个问题：https://stackoverflow.com/questions/67246010/error-message-the-server-selected-protocol-version-tls10-is-not-accepted-by-cli

JDK .18 JDBC使用多了2个参数encrypt=true;trustServerCertificate=true;

com.microsoft.sqlserver mssql-jdbc 12.3.0.jre8-preview

这个驱动包会有SSL警告提示。