CODEWITHSUNDEEP
javajakarta-eejdbcjava-ee-6java-7
Leejoy
Leejoy

Reputation: 1446

Unable to connect to MSSQL Server 2012 using sqljdbc4.jar

I am unable to connect to MSSQL Server 2012 from my Java application using sqljdbc4.jar.

Following is my code:

public static void main(String[] args) {
    String connectionUrl = "jdbc:sqlserver://172.16.0.4:1433;" +
             "databaseName=PUC;user=admin;password=admin;instanceName=mssqlserver2012";

    // Declare the JDBC objects.
    Connection con = null;
    Statement stmt = null;
    ResultSet rs = null;

    try {
        // Establish the connection.
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        con = DriverManager.getConnection(connectionUrl);

        // Create and execute an SQL statement that returns some data.
        String SQL = "SELECT TOP 10 * FROM Patron";
        stmt = con.createStatement();
        rs = stmt.executeQuery(SQL);

        // Iterate through the data in the result set and display it.
        while (rs.next()) {
            System.out.println(rs.getString(4) + " " + rs.getString(6));
        }
    }

    // Handle any errors that may have occurred.
    catch (Exception e) {
        e.printStackTrace();
    }
    finally {
        if (rs != null) try { rs.close(); } catch(Exception e) {}
        if (stmt != null) try { stmt.close(); } catch(Exception e) {}
        if (con != null) try { con.close(); } catch(Exception e) {}
    }
}

Following is the error:

com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'admin'. ClientConnectionId:1530f396-0935-4c41-92f1-016797a65edd
    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:579)
    at java.sql.DriverManager.getConnection(DriverManager.java:243)
    at Main.main(Main.java:18)

Note: The username & password is correct, I have crosschecked them. My JDK version is 1.7 update 21. when I use JTDS1.3.1 driver by changing connection string and driver class as follows:

String connectionUrl = "jdbc:jtds:sqlserver://172.16.0.4:1433/PUC;instance=mssqlserver2012;user=admin;password=admin";

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

It works, but why not with Microsoft JDBC Driver 4.0 for SQL Server?

Upvotes: 0

Views: 4098

Answers (1)

Thomas Riley
Thomas Riley

Reputation: 409

The Login SQLServerException just means that either your username or password for your MSSQL Server is wrong. I'd double check them, and remember caps!

Upvotes: 1

Related Questions