Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

TCP ports

Posted on 2008-11-17
2
Medium Priority
?
369 Views
Last Modified: 2012-06-27
How do you check what TCP ports used by MS SQL Server/MSDE?
0
Comment
Question by:4Mua
2 Comments
 
LVL 16

Expert Comment

by:JoWickerman
ID: 22982399
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
 

Accepted Solution

by:
lekash earned 200 total points
ID: 22982555
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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question