Learn About Microsoft SQL Server 2008

These questions are based on 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance
A Self Test Software Practice Test

Objective: Install and configure SQL Server 2008.
Sub-objective: Configure SQL Server instances.

Multiple answer, multiple-choice

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 also is 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.

Answer:
C, E

Tutorial:
You could enable the named pipes protocol for all the clients and 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.…


cmadmin

ABOUT THE AUTHOR

Posted in Uncategorized|

Comment:

Powered by WebDesk