java登陆链接数据库失败_与SQL Server数据库的Java连接：用户’sa’登录失败

参见英文答案 >

SqlServer: Login failed for user                                    7个

我正在尝试连接到我使用SQL Server 2012创建的数据库,但我一直收到错误.这是连接的代码：

Driver d = (Driver)Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();

String DB_URL = "jdbc:sqlserver://localhost:1433;databaseName=Tema6;user=sa;password=123456";

java.sql.Connection con = DriverManager.getConnection(DB_URL);

这是我得到的错误：

Login failed for user 'sa'. ClientConnectionId:e6335e64-ca68-4d72-8939-5b7ded951424

我已经从SQL Server Config启用了TCP / IP协议,我确信启用了’sa’帐户并且密码正确.有人可以帮帮我吗？

编辑：这是整个堆栈跟踪.

com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sa'. ClientConnectionId:e6335e64-ca68-4d72-8939-5b7ded951424

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)

at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)

at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)

at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)

at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at Connection.main(Connection.java:12)

EDIT2：用jTDS替换驱动程序后：

java.sql.SQLException: Login failed for user 'sa'.

at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)

at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2893)

at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2335)

at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:609)

at net.sourceforge.jtds.jdbc.JtdsConnection.(JtdsConnection.java:369)

at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:183)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at Connection.main(Connection.java:19)