帆软9.0连接sql server数据库失败，并且日志报以下错误

2018-12-08 20:44:17

严重:20:44:17 Druid-ConnectionPool-Create-1768614345jdbc:sqlserver://localhost:3433;databaseName= ERROR [com.fr.third.alibaba.druid.pool.DruidDataSource] create connection error, url: jdbc:sqlserver://localhost:3433;databaseName=, errorCode 0, state 08S01

2018-12-08 20:44:18

严重:20:44:18 Druid-ConnectionPool-Create-1768614345jdbc:sqlserver://localhost:3433;databaseName= ERROR [com.fr.third.alibaba.druid.pool.DruidDataSource] create connection error, url: jdbc:sqlserver://localhost:3433;databaseName=, errorCode 0, state 08S01

2018-12-08 20:44:19

严重:20:44:19 Druid-ConnectionPool-Create-1768614345jdbc:sqlserver://localhost:3433;databaseName= ERROR [com.fr.third.alibaba.druid.pool.DruidDataSource] create connection error, url: jdbc:sqlserver://localhost:3433;databaseName=, errorCode 0, state 08S01

2018-12-08 20:44:20

严重:20:44:20 Druid-ConnectionPool-Create-1768614345jdbc:sqlserver://localhost:3433;databaseName= ERROR [com.fr.third.alibaba.druid.pool.DruidDataSource] create connection error, url: jdbc:sqlserver://localhost:3433;databaseName=, errorCode 0, state 08S01

2018-12-08 20:44:21

严重:20:44:21 Druid-ConnectionPool-Create-1768614345jdbc:sqlserver://localhost:3433;databaseName= ERROR [com.fr.third.alibaba.druid.pool.DruidDataSource] create connection error, url: jdbc:sqlserver://localhost:3433;databaseName=, errorCode 0, state 08S01

2018-12-08 20:44:22

严重:20:44:22 Druid-ConnectionPool-Create-1768614345jdbc:sqlserver://localhost:3433;databaseName= ERROR [com.fr.third.alibaba.druid.pool.DruidDataSource] create connection error, url: jdbc:sqlserver://localhost:3433;databaseName=, errorCode 0, state 08S01

2018-12-08 20:44:26

警告:20:44:26 pool-16-thread-1 WARN [root] 错误代码:31300012 创建数据连接失败: 到主机的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect

2018-12-08 20:44:26

严重:20:44:26 SwingWorker-pool-14-thread-1 ERROR [root] com.microsoft.sqlserver.jdbc.SQLServerException: 到主机的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect

FineReport 断舍离 发布于 2018-12-8 20:49

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：4 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共3回答

最佳回答

zsh331Lv8专家互助
发布于2018-12-8 20:58

sql server数据库？url填写的不全(对)，参考文档写对了。

ip，端口，库名~

JDBC连接数据库-http://help.finereport.com/doc-view-101.html

举报收起评论(2)

断舍离(提问者) 我的sql server 实例名是USER-20170518SD，端口是1433，数据库的名字不会错，而且我试过可以不是数据库名，所以url应该是 jdbc:sqlserver://localhost:1433对吧，但是还是连接失败

2018-12-10 15:55

断舍离(提问者) 错误日志是：2018-12-10 15:56:16 正常:15:56:16 pool-1-thread-1 INFO [root] columnIndex:4[-1]<--->columnValue:java.util.concurrent.ExecutionException: com.microsoft.sqlserver.jdbc.SQLServerException: 到主机的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect at java.util.concurrent.FutureTask.report(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at com.fr.dav.LocalEnv.testConnection(Unknown Source) at com.fr.design.data.datapane.connect.DatabaseConnectionPane$1$1.doInBackground(Unknown Source) at javax.swing.SwingWorker$1.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at javax.swing.SwingWorker.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 到主机的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source) at com.fr.third.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1461) at com.fr.third.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1525) at com.fr.third.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2153) [java.lang.String]

2018-12-10 15:58