check if sql port is open

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

telnet can be installed by the windows admin only and he is not available for a few days..

1)you gave a link for: Microsoft® SQL Server® 2008 Management Studio Express
how will that help to see if server a can access serverb's port 1433?

2)is pkgmgr /iu:"TelnetClient" a sqlcmd?

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

but you may try/run telnet on an other machine...

ASKER

C:\Users\jimwe>pkgmgr /iu:"TelnetClient"

C:\Users\jimwe>

did not give any errors.. but nothing else either..

but i tried it and not it works..thanks..

ASKER

>>netstat need to be run on the server itslef

so how would you check from netstat

C:\Users\TPBAdmin>netstat

Active Connections

Proto Local Address Foreign Address State

Look for :1433 (local address)

Microsoft Windows [version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. Tous droits réservés.

C:\Users\leakim>netstat -na

Connexions actives

 Proto  Local Address          Foreign Address        State
TCP    127.0.0.1:1433         0.0.0.0:0              LISTENING

C:\Users\leakim>

Open in new window

SOLUTION

tangchunfeng

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

leakim971/tangchunfeng,

netstat will work only if the local machine is having SSMS installed and opened to a database, right?

with telnet, we will force it to listen and tell us if it can listen.

ASKER

also can you help me to read
TCP 127.0.0.1:1433 0.0.0.0:0 LISTENING

is 1433 running on 127.0.0.1, and no one (0.0.0.0) is listening.

SOLUTION

Racim BOUDJAKDJI

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.