You are a database administrator in your company. You create a new database named Prod1 on a SQL Server 2008 instance named Sql1. The users on your company’s LAN should have access to the Prod1 database. All the client computers are running Windows XP Professional and have the SQL Client component installed. The shared memory protocol is also enabled on all the client computers in the SQL Native Client Configuration.

What could you do to enable clients to connect to Sql1? (Choose all that apply. Each correct answer presents a unique solution.)

A.
Enable the VIA protocol for all the clients.

B.
Enable the Named Pipes protocol for Sql1 only.

C.
Enable the TCP/IP protocol for all the clients.

D.
Enable the shared memory protocol for Sql1.

E.
Enable the Named Pipes protocol for all the clients and Sql1.

Explanation:
You could enable the Named Pipes protocol for Sql1 or you could enable the TCP/IP protocol and the Named Pipes protocol for all the clients. In this scenario, the client computers should access Sql1 on the company’s LAN. Therefore, you should enable the Named Pipes protocol on both Sql1 and the client computers. The Named Pipes protocol is designed primarily for use with LANs. With this protocol, a part of memory is used by a process to pass information to another process. The information passed by the first process is used as input to the second process that is located on the same computer or on a remote computer. You can also enable the TCP/IP protocol for all the clients because the TCP/IP protocol is enabled on the server by default. Therefore, you can also use the TCP/IP protocol to enable clients to connect to Sql1. You should not enable the Virtual Interface Adapter (VIA) protocol for all the clients. The VIA protocol works only with VIA hardware and should only be used in configurations that use VIA hardware. You should not enable the Named Pipes protocol for Sql1only. You also need to enable this protocol for the client. You should not enable the shared memory protocol for Sql1 because the shared memory protocol does not support access over LANs. Using the shared memory protocol, you can only connect to a server instance running on the same computer. To view the network protocols that are currently enabled for the server, you can open SQL Server Configuration Manager and expand SQL Server Network Configuration. This will display the four possible protocols you can use and the status of each, as shown in the following image:

The client network protocols are displayed in the Client Protocols section under SQL Native Client Configuration.

Objective: Installing and Configuring SQL Server 2008 Sub-Objective: Configure SQL Server instances.

References: TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > Product Documentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration > Connecting to the SQL Server Database Engine > Client Network Configuration > Choosing a Network Protocol TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > Product Documentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration > Connecting to the SQL Server Database Engine > Server Network Configuration > Default SQL Server Network Configuration