com.microsoft.sqlserver.jdbc.SQLServerException

我用的是２００５的jar包联数据库，但出现   TCP/IP   连接失败.
package   db;

import   java.sql.Connection;
import   java.sql.DriverManager;
import   java.sql.SQLException;

public   class   DBCon   {

private   String   driver   =   "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private   String   url   =   "jdbc:sqlserver://127.0.0.1:1433;DATABASE=pubs";
private   Connection   conn   =   null;
public   DBCon()   {
try   {
Class.forName(driver);
}   catch   (Exception   e)   {
//   TODO   Auto-generated   catch   block
e.printStackTrace();
}
try   {
conn   =   DriverManager.getConnection(url,   "sa",   "sa");
}   catch   (SQLException   e)   {

数据挖掘研究院

//   TODO   Auto-generated   catch   block
e.printStackTrace();
}


}

public   Connection   getCon(){

return   new   DBCon().conn;

}

public   static   void   main(String[]   args)   {
System.out.println(new   DBCon().conn);
}

}

错误信息是这样的：
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   java.sql.DriverManager.getConnection(DriverManager.java:525)
at   java.sql.DriverManager.getConnection(DriverManager.java:171)
at   db.DBCon. <init> (DBCon.java:20)
at   db.DBCon.main(DBCon.java:36)

如果是Microsoft   Driver:

driver:
com.microsoft.jdbc.sqlserver.SQLServerDriver
url:
jdbc:microsoft:sqlserver://127.0.0.1;DatabaseName=pubs

你安装SQL   Server   了吗？
你的SQL   Server   服务启动了吗？

Create By Any-Extract(WL-AE) 数据挖掘研究院