Sql-server – telnet on port 1433 not working

portsql servertelnet

telnet some_ip 1433

On Windows 7 this line doesn't work. It says it cannot establish connection. I'm 100% percent sure that the server has this port open. For a friend of mine this line works.

I suspect 2 reasons:

  • My ISP blocks this port.
  • My system blocks it.

I turned off the firewall and windows firewall. Is there anything else I can do to make sure the problem is not related to my system configuration?

BTW, I don't know if it's important, but

telnet some_ip 80

works fine

EDIT

Wireshark log here

I replaced the ip I tried to telnet with 

<my_ip>

Best Answer

Using telnet is a very good and useful tool to trace/troubleshoot connectivity.

Here is what I do:

a) On the SQL Server box itself: telnet localhost 1433 -- This is to make sure a remote connection is even possible

b) On another box, on the same local net where the SQL server box lives: telnet 1433 -- This tells you if it is even possible to hit the port "off the box"

c) Now, if everything is working... it depends on what tools and access you have. Ex 1: Can the telnet be done from the firewall where the SQL Server lives? Ex 2: Can telnet be done from another non-local-to-SQL system that has to go through that firewall?

Often you can only get through 'b', and then you have to look at three things step by step:

  • Firewall where SQL Server lives
  • Firewall hardware on your side (where you run telnet)
  • Local OS firewall on the machine you are at running telnet (e.g. outbound filter or such blocking your outbound connection)
Related Topic