CPSRV1 is a member server in your company's Windows NT 4.0 domain, which is named CPDOMAIN. A separate Windows NT domain named CPUSERS contains all of your company's user accounts. A trust relationship exists between the CPDOMAIN domain and the CPUSERS domain.
You are installing SQL Server 2000 on CPSRV1.
You specify a service account for each SQL Server service as shown in the following table:
After the installation is complete, the MSSQLServer service and the SQLServerAgent service do not start. You need to configure the services to start without changing any security settings in either domain.
What should you do?
A．Configure the services to run under the local system account
B．Add CPSRV1 to the CPUSERS domain
C．Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the local administrators group on CPSRV1
D．Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the CPUSERS\Domain Admins groups.
E．Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the CPUSERS\Domain users groups.
参考答案
正确答案：C
解析：Explanation:MSSQLServerandMSServerAgentarerunningwithaccountsfromtheremoteCPUSERSdomain.TheseaccountdoesnothaveanyspecificlocalrightsontheSQLServer.LocaladministratorsrightsandpermissionsareneededfortheseaccountsareneededtomaketheSQLServerfunction.ByaddingtheaccountsqlsrvandsqlagentfromtheotherdomainCPUSERStotheLocaladmingroupontheSQLServer,itwouldbepossibletostarttheSQLServer.IncorrectAnswers:A:TheLocalSystemaccountdoesnotrequireapasswordanddoesnothavenetworkaccessrightsinaWindowsNT4.0domain.ThispreventstheinstanceofSQLServer2000frominteractingwithothernetworkserversinaWindowsNT4.0environment.TheSQLServercannotrunwithalocalsystemaccountinthisscenario.B:CPSRV1isintheresourcedomaininthetrustrelationship.Wecannotaddarecoursefromtheresourcedomaintoagroupinthetrustingdomain.D:TheDomainAdminsgrouprepresenttheuserswhohavebroadadministrativerightsinadomain.Theseusersareresponsibleforadministrationanddelegationofauthority.E:Bydefault,anydomainuseraccountisautomaticallyaddedtotheDomainUsersgroup.