Multiple choice technology databases

You are planning for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols will you use to achieve this goal?

  1. (a) Named Pipes

  2. (b) TCP/IP

  3. (c) Shared Memory

  4. (d) Virtual Interface Adapter

  5. (e) Multiprotocol
Reveal answer Fill a bubble to check yourself
A,B Correct answer
Explanation

SQL Server 2005 clients can connect using multiple network protocols. Named Pipes is a protocol for LAN communication, while TCP/IP is the standard protocol for both local and remote connections. These are the two most commonly used protocols for client connectivity. Shared Memory is for local connections only, VIA is specialized hardware, and Multiprotocol is a legacy option.

Keep practicing — related questions