java - JDBC SQLServerConnection“用户 'sa' 登录失败”

Question

我正在尝试与数据库连接，但这个错误让我感到沮丧。谁能帮我解决这里的问题？

我想从 Eclipse 连接到 SQL Server。

public class JDBC_Test {

  public static void SQLServerConnection() {
    try {
      String url = "jdbc:sqlserver://localhost:1433;DatabaseName=Northwind";
      String user = "sa";
      String password = "832Waseem#";
      Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
      Connection con = DriverManager.getConnection(url, user, password);
      System.out.println("Connection Created Successfully.......");
      Statement st = con.createStatement();
      ResultSet rs = st.executeQuery("select * from categories");

      while (rs.next()) {
        System.out.println(rs.getInt(1) + " " + rs.getString(2) + " " + rs.getString(3));
      }
      con.close();
      System.out.println("Connection Closed Successfully.......");
    } catch (Exception e) {
      // System.out.println("Unable to create Connection reason is as below.......");
      e.printStackTrace();
    }

  }

  public static void main(String args[]) {
    SQLServerConnection();

  }
}

我的错误：

com.microsoft.sqlserver.jdbc.SQLServerException：用户“sa”登录失败。在 com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)

标签： javasqljdbcconnection