TCP ports

How do you check what TCP ports used by MS SQL Server/MSDE?
4MuaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JoWickermanCommented:
Hi

SQL Server / MSDE uses ports 1433/1434

otherwise you might be able to look in the registry (this is from sql server
installation, not msde - so it's a crap shot, but with good odds...)

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\SuperSocketNe
tLib\Tcp]
"TcpHideFlag"=dword:00000000
"TcpPort"="1433"
"TcpDynamicPorts"=""

Cheers.
0
lekashCommented:
1433 is the default assigned number.

However, one can choose to configure it in a variety of ways.
In particular, if you are operating behind a firewall, it may have some other port.

To see the actual values, run
netstat -an
from the MS_DOS command prompt, and examine the output, to see what ports are in use.
One would typically do this while connecting to said server from some remote location, and
knowing that 'foreign address' match that with the local address, and it will show the ports.

E.g.
Proto       Local Address          Foreign Address          State
TCP       192.168.1.100:1433   192.168.1.50:1537     ESTABLISHED

Where 192.168.1.50 is your client.  This would show the SQL server is listening at 1433, on
the network interface at 192.168.1.100

Another technique would be to put some ethernet sniffer on the physical network, and watch
a transaction occur.  Again, initiate from a know place, and watch/filter for that source location.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
TCP/IP

From novice to tech pro — start learning today.