You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. You have received instruction from the CIO to prepare a new installation of SQL Server 2005. The new SQL Server 2005 database server is named Certkiller -DB01. A Domain.com user named Mia Hamm is a member of the Marketing department. You instruct her to identify the protocols that the client computers might use to connect to the server. Mia Hamm needs to identify the protocols that are needed to accomplish this goal.
What should she identify? (Choose all that apply)
A.
She should use the Multiprotocol.
B.
Mia Hamm should use the Named Pipes.
C.
She should use the Shared Memory.
D.
She should use the TCP/IP
E.
Mia Hamm should use the Virtual Interface Adapter (VIA).
Explanation:
The clients have by default TCP and Named Pipes as available protocols. You can make use of the SQL Server Client utility to manipulate the protocol ordering. The client application uses the protocols in the order specified on the client computer. When you make use of the SQL Server 2005, the protocol order is stored in the ProtocolOrder registry entry under the following registry subkey:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServerClientSNI9.0 Incorrect Answers:
C: Shared Memory can only be used on the local computer and cannot be used as a network protocol.
E: The Virtual Interface Adapter (VIA) can be used only by VIA hardware.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: client connections [SQL Server], about client network connections, choosing a network protocol