MS-SQL uses which port(s)?

MS-SQL uses which port(s)?

• A. 1433/1434
• B. 80/443
• C. 22/23
• D. 25/587

Answer: (A)

Microsoft SQL Server communicates over specific network ports. The default TCP port for SQL Server is 1433, which is what clients connect to most of the time. If you’re using a named instance or dynamic ports, the SQL Server Browser service helps clients discover the correct port by listening on UDP 1434. So, in typical configurations, you’d expect 1433 for connections and 1434 for instance discovery. Other port pairs belong to different services: 80/443 are for web traffic (HTTP/HTTPS), 22/23 are for remote access (SSH/Telnet), and 25/587 are for mail (SMTP). Thus, the relevant ports for MS-SQL are 1433 and 1434.

Microsoft SQL Server communicates over specific network ports. The default TCP port for SQL Server is 1433, which is what clients connect to most of the time. If you’re using a named instance or dynamic ports, the SQL Server Browser service helps clients discover the correct port by listening on UDP 1434. So, in typical configurations, you’d expect 1433 for connections and 1434 for instance discovery.

Other port pairs belong to different services: 80/443 are for web traffic (HTTP/HTTPS), 22/23 are for remote access (SSH/Telnet), and 25/587 are for mail (SMTP).

Thus, the relevant ports for MS-SQL are 1433 and 1434.