Question

com.microsoft.sqlserver.jdbc.SQLServerException: 用户 'sa' 登录失败。

用eclipse连接sql 2005，驱动是sql2005的、tcp/ip协议、windows和sql验证、远程连接、安全性权限授予都弄了
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url="jdbc:sqlserver://localhost:1433;DatabaseName=testsql";
conn = DriverManager.getConnection(url,"sa","sa");
求教啊、、谢谢！！
com.microsoft.sqlserver.jdbc.SQLServerException: 用户 'sa' 登录失败。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(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:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at testsql.testsql.<init>(testsql.java:32)
at testsql.testsql.main(testsql.java:44)

Answer 1

你先用sql自带的客户端登陆试一下.. 如果能进.
sql 2000 就要装一个 sp3补丁才能使用jdbc连接

Answer 2

好像是连接词写错了
com.microsoft.jdbc.sqlserver.SQLServerDriver

Answer 3

这个问题看看是不是localhost连接不上，你可以用127.0.0.1试试