CODEWITHSUNDEEP
sql-serversql-server-2008portserver-configuration
Yubaraj
Yubaraj

Reputation: 3988

Could not open connection to the host, on port 1433: Connect failed

When I try to connect from an application to a SQL Server environment on the same machine, the connection fails. I tried to telnet to following

telnet 127.0.0.1 1433

but I got following message:

Could not open connection to the host, on port 1433: Connect failed

enter image description here

Note: When I tried to ping, it was successful.

I need to enable port number 1433 on SQL Server. I am using SQL Server 2008 client (management studio) and SQL Server 2008 Express engine.

Upvotes: 7

Views: 49174

Answers (2)

Yubaraj
Yubaraj

Reputation: 3988

The YouTube video How To Connect SQL Server with Internet solved my problem, at the 5:32 mark.

Steps to enable port number 1433 on MS SQL Server 2008:

  1. Open the Start Menu
  2. Select "All Programs"
  3. Find the "SQL Server 2008" folder
  4. Select "Configuration" Tools
  5. Select "SQL Server Configuration Manager"
  6. On the left side of a new window, select "SQL Server Network Configuration"
  7. Select "Protocols for SQLEXPRESS"
  8. Select the "TPC/IP" option which is on the left panel
  9. On the "Protocol" tab, if "Enabled" is set to "No" then set it to "Yes"
  10. Then select on the "IP Address" tab
  11. Scroll down to the last option of "IPALL"; set the "TCP Port" as 1433
  12. Select "Apply" and then the "Ok" button.

Upvotes: 19

Kien Vu
Kien Vu

Reputation: 1048

Even if you did all the steps correctly Note that some vendors have a firewall (like Google Cloud), you need to add the port on the system firewall (not on the local).

Upvotes: 1

Related Questions