Question

java连接 sqlserver2005发生错误 Login failed for user 'sa'.

报错如下：com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user '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.logon(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 com.wk.db.DBmanger.getConnection(DBmanger.java:18) at com.wk.test.TestDBmanager.main(TestDBmanager.java:10) 代码如下：public interface Config {public static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";public static final String URL="jdbc:sqlserver://localhost:1433;DatabaseName=";public static final String DBNAME="book";public static final String UNAME="sa";public static final String PWD="6290902";} public class DBmanger {private static Connection con=null;public synchronized static Connection getConnection() throws ClassNotFoundException, SQLException{ if(con==null) {  Class.forName(Config.DRIVER);  con=DriverManager.getConnection(Config.URL+Config.DBNAME,Config.UNAME,Config.PWD);  } return con; }} 

Answer 1

不用java 先用别的方法测试连接到sqlserver　

Answer 2

用户sa登录失败

Answer 3

践踏’