跪求:[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
1、winXP sp2系统安装SQL Server2000标准版;
2、混合认证模式;
2、已安装SQL Server2000 sp3;
3、已安装JDBC SP3;
4、查看SQL Server服务器和客户机默认端口均为1433;
5、命令窗口中使用telnet 1433命令,错误如下:
正在连接到localhost:1433...不能打开到主机的连接, 在端口 23: 连接失败;
程序如下:
public class test {
public static void main(String[] args) throws ClassNotFoundException {
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName =test";
Class.forName(driver);
System.out.println("Driver is OK");//输出正常
try {
Connection conn = DriverManager.getConnection(url,"sa","sa");//错误
System.out.println("Connect to DBMS is OK!");
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}