Can't connect to sql server with java

Question

I'm trying to connect to a local sql server using Java and Microsoft SQL Server. I'm using sql server auth.

Here's the code:

import java.sql.*;


public class Main {
    public static void main(String[] args)  {

        String userName ="testlogin2";
        String password ="pass";

        String url ="jdbc:sqlserver://localhost/LabNoteMap;integratedSecurity=true;"; //LabNoteMap beeing target db
        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Connection conn = DriverManager.getConnection(url, userName, password);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }

        System.out.println("end");
    }
}

and the stacktrace:

"C:\Program Files\Java\jdk-9\bin\java" "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA 2017.2.5\lib\idea_rt.jar=63510:C:\Program Files\JetBrains\IntelliJ IDEA 2017.2.5\bin" -Dfile.encoding=UTF-8 -classpath C:\Users\Deus\IdeaProjects\testMYSQL\out\production\testMYSQL;C:\Users\Deus\Desktop\jdbc\sqljdbc_6.0\enu\jre8\sqljdbc42.jar Main
end
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost/LabNoteMap, port 1433 has failed. Error: "localhost/LabNoteMap. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)
    at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:242)
    at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2369)
    at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:551)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1963)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1628)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1459)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:773)
    at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1168)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:678)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:229)
    at Main.main(Main.java:13)

Process finished with exit code 0

also some ss:

Also note that in Sql server configuration, the tcp/ip is enabled and the port is set to 1433.

I guess could be a firewall? but not sure how to check for it, or maybe something else?

check your firewall to see if there is some logging about what application tried to connect to your db — Stultuske
– Stultuske, Commented Dec 27, 2017 at 14:16
Your URL is invalid, please check Building the Connection URL of the SQL Server JDBC driver documentation on the Microsoft site. You've made the mistake of assuming that all JDBC drivers follow the same structure for their URL, they don't. — Mark Rotteveel
– Mark Rotteveel, Commented Dec 27, 2017 at 14:45

Emre Kabaoglu · Accepted Answer · 2017-12-27 14:16:53Z

2

Your connection string is wrong. You should change it

String url ="jdbc:sqlserver://localhost/LabNoteMap;integratedSecurity=true;";

to

String url ="jdbc:sqlserver://localhost;databaseName=LabNoteMap;integratedSecurity=true;";

You are not targeting the db which you want to establish connection.

answered Dec 27, 2017 at 14:16

Emre Kabaoglu

13.2k4 gold badges27 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

little bear · Accepted Answer · 2017-12-27 14:34:10Z

0

private static String url="jdbc:sqlserver://localhost:1433;DatabaseName = students";

I'm using msbase.jar and mssqlserver.jar and msutil.jar, maybe you are using the wrong jar or your url is wrong (DatabaseName = ?)

edited Dec 27, 2017 at 14:34

answered Dec 27, 2017 at 14:25

little bear

11 silver badge2 bronze badges

1 Comment

Mark Rotteveel Over a year ago

It sounds like you are using an ancient version of the SQL Server driver (the SQL Server 2000 JDBC driver), in recent drivers, you only need mssql-jdbc-6.2.2.jre8.jar

Collectives™ on Stack Overflow

Can't connect to sql server with java

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related