jdbc连接sqlserver2000问题！

ningIII 2005-06-07 04:45:10

我用jdbc连接sqlserver2000

数据库：sqlserver2000 名称：sherman
服务器： win2000 server sp4 地址：192.168.10.141
jdk:1.4
驱动：在微软网站下的 sqlserver2000 for jdbc sp2

用sqlserver客户端连接数据库，没问题！
在客户端 telnet 192.168.10.141:1433，没有问题！

java代码：

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

public class Test {
public Test() {
}
public static void main(String args[]) throws SQLException {
String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String SERVANDDB="jdbc:microsoft:sqlserver://192.168.10.141:1433;DatabaseName=sherman";
String USER="ning";
String PWD="ning";
Connection con =null;
try{
Class.forName(CLASSFORNAME).newInstance();
con=DriverManager.getConnection(SERVANDDB,USER,PWD);
System.out.println("ok");
}catch(Exception e){
System.out.println("error");
e.printStackTrace();
}
if (con != null) {
con.close();
}
}
}
报错：
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]无法打开登录 'sherman' 中请求的数据库。登录失败。

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)error

at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)

at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:512)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at com.ning.sqlserver.Test.main(Test.java:26)

请问是什么原因？如何解决？？？

...全文