JDBC connection failed, error: TCP/IP connection to host failed

JavaSql ServerJdbc

Java Problem Overview

I want to connect Java class file with SQL server 2012. I have logged in with SQL server authentication, but I am receiving an error when connecting.

Error:

> The TCP/IP connection to the host 127.0.0.1, port 1433 has failed. > Error: "Connection refused: connect. 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.".

My code:

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");	//1. Register your driver
//2. get the connection object
//Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost;databaseName=aysha","sa","admin");
Connection con = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1;databaseName=aysha","user=sa","password=admin");
 //"jdbc:sqlserver://127.0.0.1:1433; Instance=SQL2008;" +       "databaseName=MB;user=sa;password=123;";
//Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=aysha","sa" , "password");
//3. Prepare a statement
Statement stmt = con.createStatement();
//4. Write the query`
String sql = "Select * from employee";
//5. Execute the statement and 
ResultSet rs = stmt.executeQuery(sql);
//6. Process the result set

while (rs.next())
{
    System.out.println(rs.getInt(1));
}

Java Solutions

Solution 1 - Java

  1. Open SQL Server Configuration Manager, and then expand SQL Server 2012 Network Configuration.
  2. Click Protocols for InstanceName, and then make sure TCP/IP is enabled in the right panel and double-click TCP/IP.
  3. On the Protocol tab, notice the value of the Listen All item.
  4. Click the IP Addresses tab: If the value of Listen All is yes, the TCP/IP port number for this instance of SQL Server 2012 is the value of the TCP Dynamic Ports item under IPAll. If the value of Listen All is no, the TCP/IP port number for this instance of SQL Server 2012 is the value of the TCP Dynamic Ports item for a specific IP address.
  5. Make sure the TCP Port is 1433.
  6. Click OK.

Solution 2 - Java

Easy Solution

Got to Start->All Programs-> Microsoft SQL Server 2012-> Configuration Tool -> Click SQL Server Configuration Manager ->Expand SQL Server Network Configuration-> Protocol ->Enable TCP/IP Right box

Double Click on TCP/IP and go to IP Adresses Tap and Put port 1433 under TCP port.

enter image description here

Solution 3 - Java

The error is self explanatory:

  • Check if your SQL server is actually up and running
  • Check SQL server hostname, username and password is correct
  • Check there's no firewall rule blocking TCP connection to port 1433
  • Check the host is actually reachable

A good check I often use is to use telnet, eg on a windows command prompt run:

telnet 127.0.0.1 1433

If you get a blank screen it indicates network connection established successfully, and it's not a network problem. If you get 'Could not open connection to the host' then this is network problem

Solution 4 - Java

Go to Start->All Programs-> Microsoft SQL Server 2012-> Configuration Tool -> Click SQL Server Configuration Manager. enter image description here

If you see that SQL Server/ SQL Server Browser State is 'stopped'.Right click on SQL Server/SQL Server Browser and click start. In some cases above state can stop though TCP connection to port 1433 is assigned.

Solution 5 - Java

Open %windir%\System32 folder and find SQLServerManagerXX.msc

For example: > C:\Windows\System32\SQLServerManager14.msc

Go to protocols settings then enable TCP/IP port is 1433 by default

enter image description here

enter image description here

Solution 6 - Java

As the error says, you need to make sure that your sql server is running and listening on port 1433. If server is running then you need to check whether there is some firewall rule rejecting the connection on port 1433.

Here are the commands that can be useful to troubleshoot:

  1. Use netstat -a to check whether sql server is listening on the desired port
  2. As gerrytan mentioned in answer, you can try to do the telnet on the host and port

Solution 7 - Java

important:
after any changes or new settings you must restart SQLSERVER service. run services.msc on Windows

Solution 8 - Java

If you are using a named instance, the port you using likely is 1434, instead of 1433, so please check that out using telnet or netstat aforementioned too.

Solution 9 - Java

Open Firewall GUI,Open TCP 1433 rule,go to scope tab and add your IP address under Remote IP Address and the problem is solved.

Categories
Recommended Java Solutions
Recommended Sql Server Solutions
Recommended Jdbc Solutions

Previous Solution:

Node.js - get raw request body using Express

node.jsExpressRequest

Next Solution:

Why did Bootstrap 3 switch to box-sizing: border-box?

CssTwitter BootstrapTwitter Bootstrap-3Boxsizer

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionAysha NijhawanView Question on Stackoverflow
Solution 1 - JavaprinceView Answer on Stackoverflow
Solution 2 - JavaMd. Naushad AlamView Answer on Stackoverflow
Solution 3 - JavagerrytanView Answer on Stackoverflow
Solution 4 - JavaAbdur RahmanView Answer on Stackoverflow
Solution 5 - JavaAli KaracaView Answer on Stackoverflow
Solution 6 - JavaJuned AhsanView Answer on Stackoverflow
Solution 7 - JavaMahdiView Answer on Stackoverflow
Solution 8 - JavaToshihikoView Answer on Stackoverflow
Solution 9 - JavaTalley OuroView Answer on Stackoverflow