You are preparing 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 can you use to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
A.
Named Pipes
B.
TCP/IP
C.
Shared Memory
D.
Virtual Interface Adapter (VIA)
E.
Multiprotocol
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