当前位置: 首页 > 问题分类 > 计算机类考试 > 微软认证 > 问题详情
问题

You are the administrator of Microsoft Windows 2000 computer. You are preparing to install SQL Server 2000 on the computer.

Your company contains a variety of client computers that will connect to the SQL server 2000 computer by using a specific Net-Library, as shown in the following table.

You need to allow the client computers to connect to the SQL Server 2000 computer. You also want to minimize the number of configuration changes required on the client computers.

Which three actions should you take? (Each correct answer presents part of the solution. Choose three)

A. Install SQL Server 2000 as a named instance.

B. Install SQL Server 2000 as the default instance.

C. Configure the new instance for Mixed Mode Authentication.

D. Configure the new instance for Windows Authentication.

E. Configure the server to use the Named Pipes, IPX/SPX, and TCP/IP Net-Libraries.

F. Configure the server to use the Multiprotocol Net-Library.

参考答案
正确答案:BCE
B,C,E 解析:Explanation:
B: We need to use a default instance of SQL Server in order to allow all the different clients to connect.

C: The client computers in this scenario will be running Windows 98, Novel NetWare and Apple Macintosh. SQL Server Authentication is required as these operating systems are not supported by Windows Authentication, however, the use of SQL Server Authentication is offered only for backward compatibility, hence we need to implement Mixed Mode Authentication.

E: By using specific communication protocols, and not the Multiprotocol Net-Library, performance would be better. Every extraneous protocol adds overhead.

Note: Configuring Net-Libraries has been simplified for applications using the SQL Server 2000 client connectivity components. Selecting the client protocols to be installed on the application computer must be done during setup, and selecting the server protocols to be enabled on the instance of SQL Server 2000 must be done during the SQL Server 2000 setup. No other configuration is required. Once setup, a client can connect to any instance of SQL Server 2000 by specifying the network name of the database computer and the instance name.

Note: SQL Server 2000 can operate in either Windows Authentication mode, which allows a user to connect through a Windows NT 4.0 or Windows 2000 user account; Mixed mode, which allows users to connect to an instance of SQL Server 2000 by using either Windows Authentication or SQL Server Authentication.

Furthermore, users who connect through a Windows NT 4.0 or Windows 2000 user account can make use of trusted connections in either Windows Authentication mode or Mixed mode. When a user connects to SQL Server 2000 with a nontrusted connection, SQL Server 2000 performs the authentication itself by checking if a SQL Server login account has been created and if the supplied password is correct. SQL Server Authentication is also used for backward compatibility because applications written for SQL Server 7.0 or earlier may require the use of SQL Server logins and passwords. In addition, SQL Server Authentication is required when an instance of SQL Server is running on Windows 98 because Windows Authentication mode is not supported on Windows 98.

Incorrect Answers:
A: The Multiprotocol Net-Library can only be used to connect to a default instance of SQL Server 2000 as it does not support named instances of SQL Server 2000 or server enumeration.

D: As client computers will be running Windows 98, Novel NetWare and Apple Macintosh, we cannot use Windows Authentication as these operating systems are not supported by Windows Authentication.

Note: Windows Authentication mode allows a user to connect through a Windows NT 4.0 or Windows 2000 user account and makes use of trusted connections. When a user connects to SQL Server 2000 a nontrusted connection, SQL Server 2000 performs the authentication itself by checking if a SQL Server login account has been created and if the supplied password is correct. Mixed mode allows users to connect to an instance of SQL Server 2000 by using either Windows Authentication or SQL Server Authentication.

F: The Multiprotocol Net-Library is used to support the different protocol that the clients use. This provides easy of administration. However, since unused protocols are installed, it also introduces overhead. This is not the best solution.

Note: The Multiprotocol Net-Library allows for the automatic selection of available network protocols to communicate with an instance of SQL Server 2000. This is convenient for connecting to multiple servers running different network protocols without having to reconfigure the client connection for each server. If the client and server Net-Libraries for TCP/IP Sockets, NWLink IPX/SPX, or Named Pipes are installed on the client and server, the Multiprotocol Net-Library will automatically choose the first available network protocol to establish a connection.

The Multiprotocol Net-Library can only be used to connect to a default instance of SQL Server 2000 as it does not support named instances of SQL Server 2000 or server enumeration.
您可能感兴趣的试题
  • You are the administrator of your company's network. Your network has five Windows 2000 server computers and 75 Windows 2000 Professional computers. The Windows 2000 Professional computers were installed by using a RIS image on one of the Windows 2000 Server computers. You need to upgrade several applications on the Windows 2000 Professional computers. The applications do not have built-in support for scripted installations.

    You want to accomplish the following goals:

    1. An unattended installation of the upgraded applications will be performed on the Windows 2000 Professional computers.

    2. Existing user environments will be maintained on the Windows 2000 Professional computers.

    3. The network name of each Windows 2000 Professional computer will be changed to match its asset tag.

    4. The RIS image and the upgraded applications will be enabled as they are added to the network.

    You take the following actions:

    1. Install the RIS image on a Windows 2000 Professional computer named Computer1.

    2. Install the upgraded applications on Computers1.

    3. Change the network name of Computer1 to %DMI-SERIAL_NUM%.

    4. Run RIPrep.exe on Computer1 to load the RIS image on to the RIS server.

    5. Start all of the Windows 2000 Professional computers, and then load the RIS image from the RIS server.

    Which result or results do these actions produce? (Choose all that apply.)

    A.An unattended installation of the upgraded applications will be performed on the Windows 2000 Professional computers.

    B.Existing user environments will be maintained on the Windows 2000 Professional computers.

    C.The network name of each Windows 2000 Professional computer will be changed to match its asset tag.

    D.The RIS image and the upgraded applications will be enabled as they are added to the network.

  • You are the administrator responsible for security and user desktop settings on your network. You need to configure a custom registry entry for all users. You want to add the custom registry entry into a Group Policy object (GPO) with the least amount of administrative effort.

    What should you do?

    A.Configure an ADM template and add the template to the GPO.

    B.Configure an INF policy and add the policy to the GPO.

    C.Configure a Microsoft Windows installer package and add the package to the GPO.

    D.Configure RIS to include the registry entry.

  • You are the network administrator for Ezonexam. The network consists of a single Active Directory domain Ezonexam.com. All network servers run Windows Server 2000.

    Your network includes a shared folder named EzonexamDocs. This folder must not be visible in a browse list.

    However, users report that they can see EzonexamDocs when they browse for shared folders.

    How should you solve this problem?

    A.Modify the share permissions to remove the All - Read permission on EzonexamDocs from the Users group.

    B.Modify the NTFS permissions to remove the Allow - Read permissions on EzonexamDocs from the Users group.

    C.Change the share name to EzonexamDocs #.

    D.Change the share name to EzonexamDocs $.

  • On a Windows 2000 Professional computer, you run a shipping application that prints packing labels to a laser printer for every outgoing shipment, 24 hours per day. During peak hours, your company ships more than 1,000 packages per hour.

    You have just purchased a second identical laser printer to aid in printing. You want to configure the printers so that the jobs are load balanced. You connect the second laser printer to the computer.

    What must you do next?

    A.Enable bi-directional support.

    B.Enable printer pooling.

    C.Configure print spooling.

    D.Configure print sharing.

×
验证