π Chapter 6 β Session 6: SQL Server, RDP & SIP
This is the last small application/port recognition session before we move into TCP vs. UDP.
Your Chapter 6 objectives specifically list:
SQL Server = TCP 1433
RDP = TCP 3389
SIP = 5060/5061
π Topics to Mark Off
β¬ SQL Server
β¬ TCP 1433
β¬ Database Client Connection
β¬ RDP
β¬ TCP 3389
β¬ Remote Desktop
β¬ Graphical Remote Access
β¬ RDP vs. Telnet
β¬ SIP
β¬ SIP 5060
β¬ SIP 5061
β¬ VoIP Signaling
β¬ SIP vs. RTP
β¬ Session Setup / Teardown
π 1. SQL Server
SQL = Structured Query Language
Your chapter specifically focuses on Microsoft SQL Server here.
SQL Server is a database platform, and clients connect to its database engine using:
TCP 1433
Your source says TCP 1433 is SQL Server's default port and that client systems use it to connect to the database engine.
π» Application β TCP 1433 β ποΈ SQL Server β Database
π§ Memory
SQL Server = Database = 1433
For Network+, you mainly need to recognize the service and port.
π¨ SQL Server Scenario
A firewall is blocking TCP port 1433.
Users can open the application, but the application cannot connect to its Microsoft database server.
What should you suspect?
β SQL Server connectivity
Because:
SQL Server = TCP 1433
π» 2. RDP β Remote Desktop Protocol
RDP = Remote Desktop Protocol
RDP lets you remotely connect to another computer and interact with its:
Graphical user interface β GUI
Your chapter describes RDP as a Microsoft protocol that lets you connect to another computer and run programs remotely.
Think:
π Your Laptop β RDP β πΌ Work Computer You see the remote DESKTOP / GUI
β RDP Port
TCP 3389
RDP
β
TCP 3389
β
π₯οΈ Remote Desktopπ§ Memory
RDP = Remote Desktop = 3389
This one is worth memorizing cold.
π RDP vs. Telnet
You already learned Telnet.
Here's the important difference.
Telnet
TCP 23
β
Remote terminal
β
TEXT / COMMAND LINERDP
TCP 3389
β
Remote computer
β
GRAPHICAL DESKTOPYour source explicitly compares them: Telnet gives a command-line prompt, while RDP gives you the actual GUI of the remote computer.
π§ Memory
Telnet = text
RDP = desktop
π¨ RDP Scenario
An employee is at home and needs to connect to their work PC and use the desktop and applications as though they were sitting in front of it.
Think:
β RDP
Port?
TCP 3389
Your chapter even uses working from home as an example of RDP usage.
π 3. SIP β Session Initiation Protocol
SIP = Session Initiation Protocol
SIP is strongly associated with:
VoIP
But there's an important detail:
SIP is primarily a:
SIGNALING protocol
It helps establish and tear down multimedia sessions.
Your chapter says SIP is used to construct and deconstruct multimedia communication sessions, including voice/video calls and videoconferencing.
Think:
β Phone A β SIP β "Let's start a call." β βοΈ Phone B
π§ What Does Signaling Mean?
Think of SIP as the protocol that handles the:
"Hey, let's start the call."
and later:
"Okay, the call is over."
It helps manage the session.
SIP
β
START CALL
β
Maintain session
β
END CALLπ§ Memory
SIP = Set up the session
β SIP Ports
Your Chapter 6 objective lists:
5060 / 5061
Your source's protocol table shows SIP associated with 5060/5061.
For memorization:
SIP
β
5060 / 5061
β
VoIP signalingπ SIP vs. RTP
This distinction will help you understand what SIP actually does.
Your chapter says SIP commonly works with RTP when setting up connections between VoIP endpoints.
Keep it simple:
SIP
Sets up/manages the call
RTP
Carries the audio/video media
Think:
SIP
=
"Let's make the call."
RTP
=
Actual voice/video flowing
during the callπ§ Memory
SIP = Setup
RTP = Real-time media
π¨ SIP Scenario
A VoIP system needs a protocol to establish and terminate calls between endpoints.
Which protocol?
β SIP
π¨ SIP Scenario #2
A firewall administrator sees traffic using ports 5060/5061.
Which service should immediately come to mind?
β SIP / VoIP signaling
π§ Today's Port Board
π SQL SERVER TCP 1433 Database connection π₯οΈ RDP TCP 3389 Remote graphical desktop π SIP 5060 / 5061 VoIP signaling Session setup / teardown
Your Chapter 6 protocol table includes SQL 1433, RDP 3389, and SIP 5060/5061 among the ports you should study for Network+.
π΄ Flashcards
β 1 β EXAM GOLD
Which TCP port is the default port for Microsoft SQL Server?
A. 445
B. 636
C. 1433
D. 3389
β 1433
β 2
What type of service is Microsoft SQL Server?
A. Remote desktop service
B. Database platform
C. VoIP signaling service
D. Time synchronization service
β Database platform
β 3 β Scenario
A client application cannot connect to its Microsoft SQL Server database because TCP port 1433 is blocked.
Which service is being affected?
A. RDP
B. SIP
C. SQL Server
D. SMB
β SQL Server
β 4 β EXAM GOLD
Which protocol provides graphical remote access to another computer?
A. Telnet
B. SIP
C. RDP
D. SQL
β RDP
β 5
Which TCP port is associated with RDP?
A. 1433
B. 5060
C. 3389
D. 445
β 3389
β 6 β Scenario
An employee wants to remotely access their office computer and interact with its full graphical desktop.
Which protocol should they use?
A. Telnet
B. SSH
C. RDP
D. SIP
β RDP
β 7
Which statement correctly distinguishes RDP from Telnet?
A. Telnet provides a GUI while RDP provides only text.
B. RDP provides a graphical desktop, while Telnet provides text-based terminal access.
C. Both use TCP 23.
D. RDP is a database protocol.
β B
β 8
Which protocol is commonly used for VoIP signaling?
A. RDP
B. SIP
C. SQL
D. SMB
β SIP
β 9 β EXAM GOLD
Which ports are associated with SIP in your Chapter 6 objectives?
A. 161/162
B. 20/21
C. 5060/5061
D. 67/68
β 5060/5061
β 10
What is the primary job of SIP in VoIP communications?
A. Store call recordings
B. Carry database traffic
C. Establish and terminate multimedia sessions
D. Assign IP addresses
β C
β 11 β Scenario
A VoIP phone needs to establish a call session with another endpoint.
Which protocol is most closely associated with setting up that session?
A. RDP
B. SMB
C. SIP
D. NTP
β SIP
β 12
Which statement correctly compares SIP and RTP?
A. RTP sets up the call while SIP carries file transfers.
B. SIP manages the communication session while RTP carries real-time audio/video.
C. SIP and RTP are database protocols.
D. Both protocols provide remote desktop access.
β B
β 13 β Port Recognition
A packet capture shows TCP traffic destined for port 3389.
Which protocol should you suspect?
A. SIP
B. SQL Server
C. RDP
D. LDAP
β RDP
β 14 β Port Recognition
A packet capture shows TCP traffic destined for port 1433.
Which service should you suspect?
A. RDP
B. SQL Server
C. SIP
D. HTTPS
β SQL Server
β 15 β Port Recognition
A VoIP firewall rule references ports 5060 and 5061.
Which protocol is most closely associated with those ports?
A. RDP
B. SQL Server
C. SMB
D. SIP
β SIP
π§ Memory Board
π SQL SERVER Database TCP 1433 π₯οΈ RDP Remote Desktop GUI TCP 3389 RDP = Desktop Telnet = Text π SIP Session Initiation Protocol VoIP SIGNALING 5060 / 5061 SIP = Setup / tear down call RTP = Carries audio/video
π― Know These Cold
SQL Server = TCP 1433
SQL Server = Database connections
RDP = TCP 3389
RDP = Graphical remote desktop
Telnet = text-based remote access
SIP = 5060/5061
SIP = VoIP signaling
SIP = Establishes and terminates multimedia sessions
SIP manages the session; RTP carries the media
After this, weβre done with the main port-recognition block from your Chapter 6 objective. Next is the major Host-to-Host section: TCP vs. UDP, where the chapter shifts from memorizing ports into understanding reliable vs. unreliable, connection-oriented vs. connectionless, acknowledgments, sequencing, windowing, and overhead.
SIP is a signaling protocol used to establish, manage, and terminate multimedia sessions such as VoIP calls.
π§ SIP = setup/teardown of the session.