You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server 2003 with the latest Service Packs and Hotfixes, while the client computers run Windows XP Professional, Windows 98 Second Edition, and Novell NetWare 6.5.
You have received instruction to prepare for a new installation of SQL Server 2005 on a member server named Certkiller -SR21. Certkiller -SR21 will host a database named CK_Sales. All Domain.com users must be able to connect to Certkiller -SR21 by computer name. A Domain.com network administrator named Rory Allen must ensure that the client computers will be able to connect to Certkiller -DB01.
Which protocols can Domain.com users use to Certkiller -SR21?
A.
TCP/IP and Named Pipes
B.
TCP/IP and IPX/SPX
C.
Virtual Interface Adapter (VIA)
D.
Shared Memory
Explanation:
By default, clients have TCP and Named Pipes as available protocols. You can manipulate the protocol ordering by using the SQL Server Client utility. The client application uses the protocols in the order specified on the client computer. If you are using SQL Server 2005, the protocol order is stored in the ProtocolOrder registry entry under the following registry subkey:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServerClientSNI9.0 Incorrect Answers:
B: SQL Server 2005 does not support IPX/SPX. The newer versions of NetWare, such as NetWare 6.5, support TCP/IP which makes it the common protocol for all clients.
C: The Virtual Interface Adapter (VIA) can be used only by VIA hardware.
D: Shared Memory can only be used on the local computer and cannot be used as a network protocol.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: client connections [SQL Server], about client network connections, choosing a network protocol