jdbc connection to SQL Server

Question

I have a problem connecting to SQL Server. I have already tried to check my other codes and resources on the web but it's not working.

JDBC Code

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:sqlserver://IP_ADD;databaseName=DB_NAME", "MY_USER", "MY_PASS");

Error Log

Error during process run: The TCP/IP connection to the host IP_ADDRESS, port
1433 has failed. Error: "connect timed out. Verify the connection properties, check that an instance of SQL Server
is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host IP_ADDRESS, port 1433 has failed.
Error: "connect timed out. Verify the connection properties, check that an instance of SQL Server is running on the host
and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1049)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:833)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:716)
        at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:841)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at LoadTextFile.main(LoadTextFile.java:40)

DB_NAME, MY_USER and MY_PASSWORD are just example credentials. You need to set up your own server and supply the appropriate database name, username and password in order to connect. — Mapsy
– Mapsy, Commented May 27, 2015 at 14:58
what is more "jdbc:sqlserver://IP_ADD;databaseName=DB_NAME" seems to be wrong. I would suggest trying "jdbc:sqlserver://host:port/database" instead (replace each field with valid credentials) — Tinki
– Tinki, Commented May 27, 2015 at 14:59
Thanks Tinki i tried that it works but the problem is not with the syntax but a firewall problem. — dimas
– dimas, Commented May 28, 2015 at 4:27

Wai Ha Lee · Accepted Answer · 2023-06-07 08:19:21Z

1

It's clear in the error:

The TCP/IP connection to the host IP_ADDRESS, port 1433 has failed.

It seems you are using a IP_ADDRESS constant for the server. Make sure the IP_ADDRESS has right host name, (or) replace it with actual server name/IP address in the database URL.

edited Jun 7, 2023 at 8:19

Wai Ha Lee

8,856102 gold badges61 silver badges100 bronze badges

answered May 27, 2015 at 14:57

K139

3,67915 silver badges17 bronze badges

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

4 Comments

dimas Over a year ago

I replaced the real ip address with IP_ADDRESS for security purposes

K139 Over a year ago

@dimas then make sure the actual values are correct, and there is an instance of sql server running. It seems either sql server is down (or) the values you are using in code are not correct.

FlipperPA Over a year ago

Are you sure you can connect to your IP address from the server connecting? A simple test is to go to command line, and try: "telnet IP_ADDRESS 1433" If it connects, then your problem is elsewhere. If it hanging on "Connecting To IP_ADDRESS..." then the problem may be firewall related.

Gord Thompson Over a year ago

@dimas - Also be aware that the Express editions of SQL Server do not listen on port 1433 (and have TCP/IP connections disabled by default if I remember correctly).

Collectives™ on Stack Overflow

jdbc connection to SQL Server

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related