java sql 登录失败_java.sql.SQLException：用户’admin’登录失败

免责声明：我之前从未使用过SQL服务器.

我正在尝试使用java代码连接到SQL Server Express.

public class Test1 {

public static void main(String[] args) throws SQLException, ClassNotFoundException {

Class.forName("net.sourceforge.jtds.jdbc.Driver");

String url = "jdbc:jtds:sqlserver://localhost:1433/POC;instance=MOHITCH-LAPTOP/SQLEXPRESS";

String user = "admin";

String password = "admin";

Connection conn = DriverManager.getConnection(url, user, password);

Statement st = conn.createStatement ();

ResultSet rs = st.executeQuery("select * from POC.dbo.poc_table");

while (rs.next())

{

System.out.println(rs.getInt(1) + " " + rs.getString(2));

}

}

}

我得到了例外：

Exception in thread "main" java.sql.SQLException: Login failed for user 'admin'.

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

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

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

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

at net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:352)

at net.sourceforge.jtds.jdbc.ConnectionJDBC3.(ConnectionJDBC3.java:50)

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

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

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

at my.java.Test1.main(Test1.java:16)

我也尝试使用MS SQL服务器Management Studio 2014登录.我成功地做到了.

这是我的数据库结构：

任何帮助都非常感谢!!

谢谢