首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
54
问题
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
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
Thisweekandnext,governments,internationalagenciesandnongovernmentalorganizationsaregatheringinMexicoCityattheWo
Writeanessayof160-200wordsbasedonthefollowingtable.Youressayshould1.describethechangesintheaveragefamilyex
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
Insteadofstayingwithonecompanyforlife,moreandmorepeoplearechangingtheirjobs.Whatisyouropiniononjobhopping?
Supposeyouwanttoapplyforajobinacompanyasanofficesecretary.Writeanapplicationemailto1)introduceyourself
Self-recommendationWriteane-mailofabout100wordsbasedonthefollowingsituation:Youwanttoapplyforapart-ti
YouhavejustcomebackfromUKasamemberofaSino-Britishculturalexchangeprogram.Writeane-mailtoyourBritishcolle
Youaretheadministratorofyourcompany’snetwork.Thenetworkisconfiguredasshownintheexhibit.YouwanttoinstallWi
随机试题
在土壤中的破伤风梭菌芽孢最长可存活
不利于保持良好护际关系的行为是
下列有关居住区内配置停车场(库)的叙述中,错误的是:[2009年第35题]
下列关于财务公司设立的条件正确的是()。
在下列税种中,既适用比例税率,又适用累进税率的是()。
阅读图文资料,回答问题。猴面包树,又称波巴布树(如图甲),主要分布在马达加斯加岛西南沿海。猴面包树喜热、耐旱,适宜生长地区的降水量300~800mm(如图乙)。树干呈桶状,直径最大可达12米,木质疏松柔软,但树皮坚韧结实,根系发达。猴面包树浑身是宝,树叶
(2016·河南)毛毛原来见了陌生人就躲避,上学一个月后,毛毛的这种行为消失了。根据加涅的学习结果分类,这里发生的学习是()
李刚到单位工作,对工作不是特别熟悉,被领导批评。找你吐苦水,请把考富当作小李,开导开导他。
神经元具有()的机能。
Notallpersonsarrestedand______withacrimeareguilty,andthemainfunctionofcriminalcourtsistodeterminewhoisguil
最新回复
(
0
)