TCP ports

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

    Expert Comment


    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


    Accepted Solution

    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.

    Proto       Local Address          Foreign Address          State

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

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Suggested Solutions

    Title # Comments Views Activity
    Copy only dates 3 59
    SP to delete duplicates 15 46
    Using field values to generate columns - oracle query 6 35
    pfSense IP Helper 4 28
    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    Configuring network clients can be a chore, especially if there are a large number of them or a lot of itinerant users.  DHCP dynamically manages this process, much to the relief of users and administrators alike!
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now