java - com.microsoft.sqlserver.jdbc.SQLServerException : Login failed for user 'sa'

Question

这个问题已经有答案了:

SqlServer: Login failed for user (16 个回答)

已关闭 5 年前。

我只是想测试我与 SQL Server 2008 的连接，如下所示:

public class ForJDBC {


    public static void main(String[] args) {




        try{

        Connection conn = DriverManager.getConnection("jdbc:sqlserver://XX.XX.X.XXX:1433;databaseName=MyDB;user=sa;password=mypassword");

        if(conn != null){

            System.out.println("Connection is Successfull");
        }

        }
        catch(SQLException ex){

           ex.printStackTrace();
        }




    }
}

但我不断收到以下异常:

com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sa'. ClientConnectionId:96f7d048-9734-4fd8-8216-21231d89b2e6
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
    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(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:270)
    at forjdbc.ForJDBC.main(ForJDBC.java:35)

当我连接到 MySQL 5.5 时，它工作正常。

我遵循的故障排除步骤:

1) 尝试在 SQL Server 管理控制台中使用“sa”用户名和密码进行日志记录使用 SQL Server Management Studio

2) 我的 Netbeans 7.4 源包文件夹中有 sqljdbc4.jar

3) 更新至 Java 8

请让我知道我做错了什么，并让我知道我是否可以回答任何问题。

Answer 1

连接字符串问题...

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

连接连接=DriverManager .getConnection("jdbc:sqlserver://localhost:1433;\SQLEXPRESS;databaseName=Tema6","sa","123456")