URL=jdbc:jtds:sqlserver://localhost:1433/test;USER=sa;pwd=sa; get the sql connection failed
java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:385)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at hjl.db.DBConnectionPool.newConnection(DBConnectionManager.java:462)
at hjl.db.DBConnectionPool.getConnection(DBConnectionManager.java:363)
at hjl.db.DBConnectionManager.getConnection(DBConnectionManager.java:144)
at hjl.db.NewDBFactory.getConnectionExt(NewDBFactory.java:200)
at hjl.db.NewDBFactory.getAllTableNames(NewDBFactory.java:1119)
at hjl.web.db.WebConfig.init(WebConfig.java:57)
at hjl.web.servlet.ContextListener.contextInitialized(ContextListener.java:15)
……………………………
解决方案:
SQL Server 2005 网络配置中的TCP/IP为禁用,所以错误,改为已启用。具体操作如下:
-------------------------重要,要不你找不到-------------------------------
首先必须打开已注册的服务窗口,在SQL Server 2005 Management Studio--视图---已注册的服务器,然后点击你要修改的实例右键
(1)打开SQL Server 配置管理
(2)转到SQL Server 2005 网络配置->MYSQLSERVER的协议
(3)将TCP/IP设置为启用
(4)双击TCP/IP项,转到IP 项
(5)IP All中设置TCP Port为1433
(6)重新启动服务