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

Question

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 :

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 1

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=====