Sql Server Jdbc Error: The Tcp/Ip Connecter To The Host Failed

I had installed SQL SERVER 2014 Express edition as well as I was trying to connect to SQL SERVER from Java plan using JDBC, but I was repeatedly getting next error:

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connexion to the host localhost, port 1433 has failed. Error: "connect timed out. Verify the connexion properties. Make certain that an event of SQL Server is running on the host as well as accepting TCP/IP connections at the port. Make certain that TCP connections to the port are non blocked past times a firewall.".Error spell closing connexion !!null

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:241)
at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2243)
at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309)
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(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Testing.main(Testing.java:42)

I had checked that event of Microsoft SQL SERVER was already running, every bit I was able to connect to it using SQL SERVER Management Studio (SSMS client). I had every bit good checked the JDBC URL, it's right as well as also, JDBC driver is including inwards CLASSPATH. So what was wrong? Why I was getting this error? as well as finally, how I managed to cook this error? Read on ....

Cause of fault TCP/IP connexion to the host Failed

If y'all are getting this fault afterwards installing SQL SERVER 2012 or 2014 spell kickoff fourth dimension trying to connect from Java plan using JDBC, as well as thence it's most probable that your SQL SERVER is non nevertheless configured to psyche for TCP/IP connexion on port 1433.

If y'all create got already configured your MSSQL server to psyche on TCP/IP traffic on port 1433 then it could hold upward whatsoever of next iii reasons:

• Firewall is blocking the incoming connection
• SQL SERVER is non running on the host
• The port y'all create got configured is non correct, i.e. its non 1433

If the SQL SERVER limited is non running as well as thence but start your SQL Server, y'all tin practice thence past times going into Windows Services tab or you tin every bit good start SQL Server from "SQL Server Configuration Manager", every bit shown below:

By default, when y'all install Microsoft SQL server inwards Windows 8.1, it register itself every bit Windows service as well as automatically starts when y'all log into Windows. Btw, if y'all are novel into JDBC Blue Planet as well as non done much operate on Java application interfacing database, as well as thence y'all should cheque out Core Java, Volume II--Advanced Features, tenth Edition past times Cay S. Horstmann, 1 of the best books to acquire advanced Java concepts.

TCP/IP connexion to the host Failed: Solution

The solution is to ensure that your SQL Server event is listening on the port. Follow these steps to ensure that SQL SERVER 2014 is start listening on port 1433:

1. Go to Start->All Programs-> Microsoft SQL Server 2012-> Configuration Tool
2. Click SQL Server Configuration Manager
3. Expand SQL Server Network Configuration-> Protocol
4. Enable TCP/IP Right box
5. Double Click on TCP/IP as well as become to IP Addresses Tap as well as Put port 1433 nether TCP port.

In Windows 8.1, y'all tin every bit good press Windows + c as well as click on Search ikon to start searching for SQL Server Configuration Manager. Once constitute but click on it to open.

Anyway, 1 time y'all got to the higher upward hide but double click on highlighted TCP/IP link as well as this volition opened upward the next window, brand certain y'all travel inwards TCP Port every bit 1433. That's it.

That's all virtually how to cook The TCP/IP connexion to the host localhost, port 1433 has failed error spell connecting to SQL SERVER from Java using JDBC API. You every bit good require to create user as well as logins inwards social club to connect using JDBC as well as type iv JDBC driver. I am going to post service that information presently inwards adjacent dyad of articles.


Related Tutorials as well as Guide
If y'all similar this tutorial as well as wants to acquire to a greater extent than virtually troubleshooting as well as debugging unlike fault inwards Java, delight encounter next tutorials:

• How to cook Unsupported major.minor version 52.0 fault inwards Java [solution]
• Failed to connect to Queue using WebSphere MQ Series fault [solution]
• java.sql.SQLException: No suitable driver constitute for jdbc:jtds:sqlserver [fix]
• How to fix java.lang.classnotfoundexception sun.jdbc.odbc.jdbcodbcdriver erorr [solution]
• Solution of JDBC fault java.lang.ClassNotFoundException: org.postgresql.Drive [solution]
• How to bargain with java.lang.classnotfoundexception oracle.jdbc.driver.oracledriver? [solution]
• Root displace of  java.lang.ClassNotFoundException: com.mysql.jdbc.Drive fault inwards Java? [solution]
• Cause as well as solution of java.sql.SQLException: No suitable driver : sqljdbc4.jar [solution]
• Root displace java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver inwards Java? [analysis]
• Step past times Step Guide to connect MySQL database using JDBC API (guide)
• java.lang.ClassNotFoundException: org.springframework.web.servlet.DispatcherServlet [fix]
• Java conduct to connecting Oracle 10g database using JDBC sparse driver (guide)

Further Learning
JSP, Servlets as well as JDBC for Beginners: Build a Database App
Complete JDBC Programming Part 1 as well as 2
Java Platform: Working alongside Databases Using JDBC