com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed [duplicate]

Question

I keep on getting this error. I tried one solution from Stack Overflow (below), which did not work for me: SQL Exception while connecting to SQL server

I tried allowing port 1433 in the Windows firewall by using a link, that did not work either. Refer to section "To open a port in the Windows firewall for TCP access" http://msdn.microsoft.com/en-us/library/ms175043.aspx

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, 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.

Please help me to fix this problem.

Answer 1

You need to go to Start > 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.

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

In these properties, remove all the TCP Dynamic Ports and add value of 1433 to all TCP ports, and restart your SQL Server Services > SQL Server

And it's done.

Answer 2

Steps

• Open the Sql Server Configuration Manager (Start -> Programs -> Microsoft SQL Server 2008 -> Configuration Tools)

• Expand SQL Server Network Configuration -> [Your Server Instance]

• Double click TCP/IP

• Under Protocol:

• Ensure Enabled is Yes

• Under IP Addresses:

• Scroll to the bottom and set the TCP Port under IPAll, (1433 by default)

• Find the IP address you want to connect to and set Enabled and Active to Yes