sqlserver2005 到主机 的 TCP/IP 连接失败异常解决方法

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

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启用，然后重启一下服务就可以了！