Multiple choice technology databases

You want to access a SQL Server instance that is not in your domain. The only network protocol you can use is TCP/IP. Which ports do you need to open on the firewall that is between your computer and the server running SQL Server?

  1. SQL Server uses a random port

  2. 1433

  3. 1433 and 1434

  4. It depends; the port can be chosen by an administrator
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

SQL Server's default port is 1433, but administrators can configure custom ports. The SQL Server Browser service (port 1434) helps clients find named instances. Since port configuration is customizable, Option D is correct - you need to know what port your specific instance uses, not assume a fixed port.

Keep practicing — related questions