You are a database administrator in your company. You create a new database named Prod1 on a SQL Server2008 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 aunique 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 all the clients and Sql1 or you could enable the TCP/IP protocolfor all the clients. In this scenario, the client computers should access Sql1 on the company’s LAN. Therefore, youshould enable the Named Pipes protocol on both Sql1 and the client computers. The Named Pipes protocol isdesigned primarily for use with LANs. With this protocol, a part of memory is used by a process to passinformation to another process. The information passed by the first process is used as input to the secondprocess that is located on the same computer or on a remote computer. You can also enable the TCP/IP protocolfor all the clients because the TCP/IP protocol is enabled on the server by default. Therefore, you can also usethe 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 onlywith VIA hardware and should only be used in configurations that use VIA hardware. You should not enable the Named Pipes protocol for Sql1 only. You also need to enable this protocol for theclient. You should not enable the shared memory protocol for Sql1 because the shared memory protocol does notsupport access over LANs. Using the shared memory protocol, you can only connect to a server instance runningon the same computer. To view the network protocols that are currently enabled for the server, you can open SQL Server ConfigurationManager and expand SQL Server Network Configuration . This will display the four possible protocols you canuse 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 ClientConfiguration.
Objective:
Installing and Configuring SQL Server 2008Sub-Objective:
Configure SQL Server instances.References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration > Connectingto the SQL Server Database Engine > Client Network Configuration > Choosing a Network Protocol TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration > Connectingto the SQL Server Database Engine > Server Network Configuration > Default SQL Server Network Configuration