70-642 · Question #364
Your network contains an Active Directory domain named contoso.com. The domain contains a server named Server1 that has Microsoft SQL Server 2008 R2 installed. You need to configure the Windows…
The correct answer is A. TCP 1433. SQL Server is a Winsock application that communicates over TCP/IP by using the sockets network library. SQL Server listens for incoming connections on a particular port. The default port for SQL Server is 1433. The port doesn't need to be 1433, but 1433 is the official Internet…
Question
Your network contains an Active Directory domain named contoso.com. The domain contains a server named Server1 that has Microsoft SQL Server 2008 R2 installed. You need to configure the Windows Firewall on Server1 to allow client computers access to the SQL Server installation. Which port or ports should you allow through Windows Firewall?
Options
- ATCP 1433
- BTCP 587 and UDP 587
- CUDP 67 and UDP 68
- DTCP 53 and UDP 53
- ETCP 546 and TCP 547
- FUDP 546 and UDP 547
- GTCP 636
- HUDP 1433
- JUDP 995
How the community answered
(24 responses)- A71% (17)
- B4% (1)
- C13% (3)
- E8% (2)
- H4% (1)
Explanation
SQL Server is a Winsock application that communicates over TCP/IP by using the sockets network library. SQL Server listens for incoming connections on a particular port. The default port for SQL Server is 1433. The port doesn't need to be 1433, but 1433 is the official Internet Assigned Number Authority (IANA) socket number for SQL Server.
Topics
Community Discussion
No community discussion yet for this question.