首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of Microsoft Windows 2000 computer. You are preparing to install SQL Server 2000 on the computer. You
You are the administrator of Microsoft Windows 2000 computer. You are preparing to install SQL Server 2000 on the computer. You
admin
2009-05-19
58
问题
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.
选项
答案
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.
转载请注明原文地址:https://kaotiyun.com/show/BuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Inthe1930s,anAmericanmeatcompanycameoutwithaspicedhamproductsoldinacan.Beforelong,Spam,asitwascalled,be
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
[A]Butworkisunderwaytogetcomputerstocapturehumanlifeandrememberitaspeopledo—recallingbitsofexperiencethata
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
Thisweekandnext,governments,internationalagenciesandnongovernmentalorganizationsaregatheringinMexicoCityattheWo
Youliveinaroomincollegewhichyousharewithanotherstudent.Youfinditverydifficulttoworktherebecauseyourroomma
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
NextmonthBritonswillhaveyetmoresmartphonestochoosefrom,whendevicesfromWiko,atwo-year-oldFrenchcompany,goons
随机试题
心室肌细胞动作电位平台期的主要离子基础是()
现代各国的亲属制度是以什么为本位的()
某妇,30岁,闭经1年,体重明显增加,脸上痤疮越来越多,内分泌性雄性激素高出正常2倍,B超检查示双侧卵巢体积分别为5cm×4.3cm×2.7cm,4.8cm×4.5cm×3.0cm,该患者属于哪种闭经( )。
结合犯罪构成理论以及刑法分则的相关规定分析,以下案件哪些不构成侵占罪?
某实施监理的工程,建设单位与甲施工单位按《建设工程施工合同(示范文本)》签订了合同,合同工期2年。经建设单位同意,甲施工单位将其中的专业工程分包给乙施工单位。工程实施过程中发生以下事件。事件1:甲施工单位在基础工程施工时发现,现场条件与施工图不符
【背景资料】某等外级公路,起讫桩号K0+000~K7+300,沿途经过工业废矿区域,该地多雨潮湿,雨量充沛,随着当地旅游资源的开发,该路段已成为重要的旅游公路,经专家论证,确定该等外级公路升级改造成三级公路,路面结构形式,如图2所示。施工中发生如下事
基坑初期排水总量的计算,应考虑的因素包括()。
根据唐律的规定,下列共同犯罪行为,不区分首犯和从犯的是()。
WhatisAnthonyHorowitzfamousfor?
Whenweworryaboutwhomightbespyingonourprivatelives,weusuallythinkabouttheFederalagents.Buttheprivatesector
最新回复
(
0
)