Which port and protocol is commonly used by Microsoft SQL Server?

Which port and protocol is commonly used by Microsoft SQL Server?

• A. 3306 TCP
• B. 1433 TCP
• C. 1883 TCP
• D. 6379 TCP

Answer: (B)

The common way to connect to Microsoft SQL Server is using TCP on port 1433. This port is the default listening port for the SQL Server Database Engine, so standard clients reach the server at that address and port unless a different port is configured. If you set up a named instance, SQL Server can listen on a dynamic port and the SQL Server Browser service helps clients discover it via UDP on port 1434, but for everyday connections the default is TCP 1433. The other options correspond to different technologies (3306 is MySQL, 1883 is MQTT, 6379 is Redis) and are not the typical SQL Server ports.

The common way to connect to Microsoft SQL Server is using TCP on port 1433. This port is the default listening port for the SQL Server Database Engine, so standard clients reach the server at that address and port unless a different port is configured. If you set up a named instance, SQL Server can listen on a dynamic port and the SQL Server Browser service helps clients discover it via UDP on port 1434, but for everyday connections the default is TCP 1433. The other options correspond to different technologies (3306 is MySQL, 1883 is MQTT, 6379 is Redis) and are not the typical SQL Server ports.