Multiple choice technology databases

On which port does SQL server runs.

  1. 1433

  2. 1434

  3. 1432

  4. 1435
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SQL Server's default port for TCP/IP communication is 1433. This is the well-known port used by the SQL Server Database Engine to listen for incoming client connections. Port 1434 is used for the SQL Server Browser Service (which helps clients find named instances), while 1432 and 1435 are not standard SQL Server ports.

AI explanation

To answer this question, we need to understand the default port on which SQL Server runs.

Option A) 1433 - This option is correct. SQL Server typically runs on port 1433 by default. This port is used for the default instance of SQL Server.

Option B) 1434 - This option is incorrect. Port 1434 is used for the SQL Server Browser service, which helps clients locate named instances of SQL Server on a network. It is not the default port for SQL Server itself.

Option C) 1432 - This option is incorrect. Port 1432 is not the default port for SQL Server.

Option D) 1435 - This option is incorrect. Port 1435 is not the default port for SQL Server.

The correct answer is option A) 1433. This option is correct because it represents the default port on which SQL Server runs.

Keep practicing — related questions