up vote 0 down vote favorite
share [g+] share [fb]

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.

link|improve this question
28% accept rate
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
feedback

3 Answers

up vote 7 down vote

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

link|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
feedback
up vote 2 down vote

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.

link|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
feedback
up vote 0 down vote

Port Query 2.0

link|improve this answer
The general consensus here is that we try to add a little descriptive text instead of pure linkage. – pauska Jul 29 '11 at 11:21
Of course. I would normally add something but I haven't actually used the tool so figured the technote would be the better explanation. – Mitch Jul 29 '11 at 18:06
feedback

Your Answer

 
or
required, but never shown
discard

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