CompTIA Network+ Practice Test

Disable ads (and more) with a membership for a one time $2.99 payment

Prepare for the CompTIA Network+ Exam. Utilize interactive quizzes and multiple-choice questions with explanations. Boost your readiness and achieve exam success now!

Each practice test/flash card set has 50 randomly selected questions from a bank of over 500. You'll get a new set of questions each time!

Practice this question and more.

What is the common port used by Microsoft SQL Server (MS-SQL)?

UDP/514
TCP/3389
TCP/1433
TCP/5060

The correct answer is: TCP/1433

The common port used by Microsoft SQL Server, also known as MS-SQL, is TCP/1433. This port is designated for SQL Server's default instance and is essential for establishing a connection between the SQL Server and client applications that request database services. By using this standard port, network configurations and firewall rules can be easily managed, as many database tools automatically seek out the SQL Server on this specific port. Other options represent different services: UDP/514 is primarily associated with syslog services, TCP/3389 is the port used for Remote Desktop Protocol (RDP), allowing remote management of Windows systems, and TCP/5060 is typically utilized for Session Initiation Protocol (SIP) in VoIP communications. Understanding these distinctions is crucial for network security and managing traffic effectively within a network.