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

sql-server-2008 port server-configuration
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=====

Related questions

How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More
How to Delete using INNER JOIN with SQL Server?

I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, Line 15 Incorrect syntax near the keyword 'INNER'. My code: DELETE FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' …

Read More
How to check if a column exists in a SQL Server table?

I need to add a specific column if it does not exist. I have something like the following, but it always returns false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTableName' AND COLUMN_NAME = 'myColumnName') How can …

Read More