7

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

Yubaraj
  • 3,800
  • 7
  • 39
  • 57
  • Can you post your connection string and the exact error that you're getting? For SQL Server Express, the default is to connect using `\SQLEXPRESS` instead of just ``. If you need to enable remote connections or to do some general troubleshooting with this stuff, then perhaps [this](http://www.linglom.com/it-support/enable-remote-connection-on-sql-server-2008-express/) resource could be of assistance? – nkvu Aug 11 '13 at 16:16
  • I did but telnet is still not working. I connect using windows authentication and sql server authentication mode from management studio it is working fine. If I succeed to telnet then my application will definitely connect to database server. Can you please explain. – Yubaraj Aug 11 '13 at 16:41
  • Are your application and SQL Server instance on separate machines or the same machine? If you can connect via Management Studio then that means your SQL Server instance is up and running - it could also be possible that it is listening on a different port (you should just confirm in `SQL Server Configuration Manager`). – nkvu Aug 11 '13 at 17:36
  • [Here](http://www.razorsql.com/docs/support_sqlserver_express.html) are some instructions on finding the port which SQL Server Express is listening on – nkvu Aug 11 '13 at 17:42
  • Yes your link is also good. I solved from youtube. Anyway thanks for co-operation. I am providing link on my answer. That may make easy to others. – Yubaraj Aug 11 '13 at 18:17

2 Answers2

17

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

Community
  • 1
  • 1
Yubaraj
  • 3,800
  • 7
  • 39
  • 57
0

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).

Kien Vu
  • 460
  • 4
  • 8