在连接SQL SERVER2005的时候,出现了下面的异常.:
com.microsoft.sqlserver.jdbc.SQLServerException: 用户 'SA'登录失败。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.processLogon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(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(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
-------------------------------------------------------------
具体的连接部分的代码如下:
String url="jdbc:sqlserver://localhost:1433;DatabaseName=test1";
String userName="SA";
String psw="";
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection connection=DriverManager.getConnection(url,userName,psw);
}
……
-------------------------------------
初步怀疑是SQL2005的设置哪里有问题。望指点~~~谢谢了
com.microsoft.sqlserver.jdbc.SQLServerException: 用户 'SA'登录失败。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.processLogon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(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(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
-------------------------------------------------------------
具体的连接部分的代码如下:
String url="jdbc:sqlserver://localhost:1433;DatabaseName=test1";
String userName="SA";
String psw="";
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection connection=DriverManager.getConnection(url,userName,psw);
}
……
-------------------------------------
初步怀疑是SQL2005的设置哪里有问题。望指点~~~谢谢了
即使我不用SA登陆.用我默认的登陆名登陆也不行.也是同样的异常。另外问多一个问题,我有一个登陆名,在SQL SERVER那显示是叫作COMPUTER\aa,这样我连接时用的userName是用aa还是COMPUTER\\aa呢?