208k views
1 vote
Which TCP/IP port does SQL Server run?
A) 80
B) 1433
C) 8080
D) 3306

User EugenSunic
by
7.5k points

1 Answer

5 votes

Final answer:

SQL Server typically runs on TCP/IP port 1433, which is essential for configuring firewall rules and troubleshooting connectivity issues (option B).

Step-by-step explanation:

The student has inquired about which TCP/IP port SQL Server runs on. The correct answer is B) 1433. SQL Server uses this default port to communicate with other database systems and applications. However, administrators can configure SQL Server to use a different port if necessary for their network requirements.

The use of TCP/IP ports is central to managing network communication in different technology systems, including databases like SQL Server. Specifically, port 1433 is assigned for SQL Server's use over TCP when an instance is configured to use that protocol. It is important to be aware of the correct ports to configure firewalls or if you are trying to troubleshoot connectivity issues.

Hence, the answer is option B.

User Katze
by
8.1k points