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

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 Ezonexam.com's network.

    You want to connect your Windows 2000 Professional computer to a new TCP/IP based laser print device. The print device is Plug and Play compliant and is included on the current Hardware Compatibility List (HCL). When you attempt to create a new TCP/IP printer port you receive the following error message:

    "Specified Port cannot be added. The port already exists."

    You want to be able to use the new TCP/IP printer.

    What should you do?

    A.Modify the properties of the existing printer port to use the new print device.

    B.Change the LPT port setting to bidirectional in the BIOS on your computer.

    C.Change the LPT port setting to enable legacy Plug and Play detection on your computer.

    D.Obtain and install the WDM-compliant device drivers and printing software for the printer.

  • You are the administrator of a Windows 2000 Professional computer named Computer1. Computer1 has a shared color laser printer named Printer1. Printer1 will not turn on.

    The printer queue for Printer1 has three jobs waiting to print. You want to enable the three waiting print jobs to print to an identical print device, which has been shared as Printer2 on Computer2. You also want to connect users who currently connect to Printer1 to automatically use Printer2 without having to reconfigure their default printer.

    What should you do?

    A.Enable bidirectional support for Printer1.

    B.Change the share name of Printer2 to Printer1.

    C.Configure Printer1 to add a port, and set the port to \\Computer2\Printer2.

    D.Configure the printer server properties to use the path \\Computer2\$Winnt$\System32\Spool\Printers.

  • You are the administrator of your company's network. A user named Paul in the service department has a Windows 2000 Professional computer. Paul needs to access the files that are in a shared folder on his computer. A local group named Sales has permissions to access the data. Paul is a member of the Sales local group but he cannot access the file he needs.

    What should you do?

    A.Grant Paul NTFS permission so that he can access any parent folder to files in the shared folder.

    B.Share the Sales folder and grant Paul shared folder permission to access the shared Sales folder.

    C.Remove Paul from any other group that has been explicitly denied access to the Sales folder.

    D.Delete the Sales local group and recreate it. Add individual user accounts from the Sales department back into Sales local group.

  • You are upgrading computer1 and computer2 from Windows NT Workstation 4.0 to Windows 2000 Professional. You successfully upgrade computer1. During the upgrade of computer2, a series of power outages interrupts the upgrade.

    You discover that the upgrade of computer2 is incomplete. Furthermore, you find that computer2 can no longer run Windows NT workstation 4.0. Computer2 does not support booting from the Windows 2000 Professional CD-ROM. You decide to use computer1 to help recover the failed upgrade.

    What should you do?

    A.On computer1, copy the CD-ROM driver and system files named ntdetect, ntbootdd.sys, Ntdll.dll and Setupldr.bin to a formatted floppy disk. On computer2, restart the computer by using the floppy disk. Then run WinNT32/debug from the Windows 2000 Professional CD-ROM.

    B.From computer1, copy the CD-ROM driver and system files named Ntdetect, Ntbootdd.sys, Ntdll.dll, and Setupldr.bin to a formatted floppy disk. On the computer2, restart the upgrade by using the floppy disk. Then run WinNT32/rx from the Windows 2000 Professional CD-ROM.

    C.On the computer1, run Makebt32.exe from the Bootdisk folder on the Windows 2000 Professional CD-ROM. On computer2, restart the upgrade by using the newly created floppy disks.

    D.On computer1, perform. a remote installation from a network share. On computer2, when the text portion of setup has completed, resume the installation by using the Setup Manager.