Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Trying to open a hole on a windows box to access sql server.

How can I test to see if the port is open (without using sql to test a login etc.)

I'm looking for a more generic way of testing w/o involving sql server just to isolate that problem of not being able to connect i.e. is it a login issue or a connection/firewall issue.

share|improve this question
    
I would verify that you mean 1443 and not 1433, which is the default for SQL. –  Kevin Garber Dec 8 '09 at 16:48
    
actually it is 1433 –  user2659 Dec 8 '09 at 17:36

2 Answers 2

You can use a port scanning tool such as NMAP or just simply telnet to the port in question if it is a TCP port. telnet host port - Example would be telnet server01 1433

share|improve this answer
    
Just today I installed telnet in win-7 just for this purpose. telnet still has its excellent uses. –  nos Dec 8 '09 at 17:26
    
+1 I use PuTTY to make telnet connections on W7, since I already have it installed for SSH. Works great. –  MDMarra Jul 28 '11 at 18:01

First I'd verify that the server in question is actually listening on 1443. Simplest way to do that is probably (on the server, in a cmd window) netstat -an | find "1443" and see what you get back.

Second, if it's a TCP connection you're looking for, you may be able to telnet <hostname> 1443 and see if you get a connection. You won't be able to do anything with it, but that should tell you if you can establish one.

If you're looking for UDP, I'd be surprised if you had a good way to establish a connection on a connectionless protocol.

share|improve this answer
    
I was just about to edit and add the netstat option as well - you beat me to it. :) –  Kevin Garber Dec 8 '09 at 16:46

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.