sqlserver2005 到主机的 TCP/IP 连接失败错误解决办法

原创

mb644638dfa963e 2023-04-26 13:26:39 博主文章分类：sqlserver开发相关 ©著作权

文章标签 Java DAO Microsoft SQL JDBC 文章分类 jQuery 前端开发

©著作权归作者所有：来自51CTO博客作者mb644638dfa963e的原创作品，请联系作者获取转载授权，否则将追究法律责任

[code]

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.connect(Unknown Source) 

 at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source) 

 at java.sql.DriverManager.getConnection(Unknown Source) 

 at java.sql.DriverManager.getConnection(Unknown Source) 

 at com.diaoer.dao.impl.ConnectionManagerSqlserverImpl.init(ConnectionManagerSqlserverImpl.java:16) 

 at com.diaoer.dao.impl.DataOperatorSqlserverImpl.init(DataOperatorSqlserverImpl.java:9) 

 at com.diaoer.dao.impl.DataOperatorSuper.clear(DataOperatorSuper.java:61) 

 at com.diaoer.generator.IdGenerator.getEntity(IdGenerator.java:39) 

 at com.diaoer.generator.IdGenerator.saveRandomIndex(IdGenerator.java:30) 

 at com.diaoer.generator.IdGenerator.main(IdGenerator.java:18) 

Exception in thread "main" java.lang.NullPointerException 

 at com.diaoer.dao.impl.DataOperatorSuper.clear(DataOperatorSuper.java:61) 

 at com.diaoer.generator.IdGenerator.getEntity(IdGenerator.java:39) 

 at com.diaoer.generator.IdGenerator.saveRandomIndex(IdGenerator.java:30) 

 at com.diaoer.generator.IdGenerator.main(IdGenerator.java:18)

解决办法：将Sql server configuration Manager目录下的sql server2005网络配置下的MSSQLSERVER的协议下的tcp/ip启用，然后重启一下服务就可以了！

[/code]