The Tcp/ip Connection To The Host Localhost, Port 1433 Has Failed

I'm getting this 2 errors repeatedly when I'm trying to connect eclipse with sql server through jdbc. Could anyone help me with this or explain why am I getting this? 1. The TCP/IP

Solution 1:

You need to Go toStart> Microsoft SQL Server > Configuration Tools >SQL Server Configuration Manager

When it opens Go to

SQL Server Configuration Manager >SQL Server Network Configuration > Protocols for SQLExpress 

Where you'll find the Protocol TCP/IP, if disabled then Enable it Click on TCP/IP, You'll find its properties.

In this properties Remove All the TCP Dynamic Ports and Add value of 1433 to all TCP Port and restart your SQL Server Services > SQL Server

And Its Done...

Solution 2:

For this kind of issue - you can resolve by checking whether all sql server related services are running or not.

TOcheckStart-> Run -> services.msc 
check services related tosqlasSQL Server (MSSQLSERVER)
SQL Server Agent (MSSQLSERVER)
SQL Server Analysis Services (MSSQLSERVER)
SQL Server Browser
SQL Server Integration Services 10.0SQL Server Reporting Services (MSSQLSERVER)
SQL Server VSS Writer

Start all the above services. and set to start up type to Automatic.

SQL Active Directory Helper Service is not required to keep running.

It can used to deal with error SQL server connection error 2 and with he TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused:

Solution 3:

If you are running SQLSERVER EXPRESS:

Use "SQL Server Configuration Manager" or write "mmc.exe" on Win+R and search "SQL Server Network Configuration", in the "Protocols for SQLEXPRESS" enable the option TCP/IP

I hope than this works for somebody!!