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

Yubaraj picture Yubaraj · Aug 11, 2013 · Viewed 31.5k times · Source

Today I installed SQL Server. And I tried to connect from an application that SQL Server. But connection failed. I tried to telnet to following

telnet 127.0.0.1 1433

but I got following message :

enter image description here

Note : I tried to ping it is successful.

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

Thanks

Answer

Yubaraj picture Yubaraj · Aug 11, 2013

I Solved my issue from this link at 05.32 minutes.

Steps to enable port number 1433 on mssql server 2008:

  1. Start
  2. All Programs
  3. SQL server 2008
  4. Configuration Tools
  5. SQL server configuration manager
  6. On the left side of new window SQL Server network configuration
  7. Protocols for SQLEXPRESS
  8. Double click on TPC/IP which is on left panel
  9. On Protocol tab if Enabled is No Then Make Yes
  10. Then click on IP Address tab
  11. Scroll down and last IPALL, set TCP Port as 1433
  12. Click Apply and then Ok button.

====Successfull=====