πŸ—„ 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 LINE

RDP

TCP 3389
↓
Remote computer
↓
GRAPHICAL DESKTOP

Your 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.