You are the administrator of a new Microsoft Windows 2000 Server computer named CPSRV1. CPSRV1 is a member server in your compan

admin2009-05-19  13

问题 You are the administrator of a new Microsoft Windows 2000 Server computer named CPSRV1.
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: MSSQLServer and MSServerAgent are running with accounts from the remote CPUSERS domain. These account does not have any specific local rights on the SQL Server. Local administrators rights and permissions are needed for these accounts are needed to make the SQL Server function. By adding the account sqlsrv and sqlagent from the other domain CPUSERS to the Local admin group on the SQL Server, it would be possible to start the SQL Server.

Incorrect Answers:
A: The Local System account does not require a password and does not have network access rights in a Windows NT 4.0 domain. This prevents the instance of SQL Server 2000 from interacting with other network servers in a Windows NT 4.0 environment. The SQL Server cannot run with a local system account in this scenario.

B: CPSRV1 is in the resource domain in the trust relationship. We cannot add a recourse from the resource domain to a group in the trusting domain.

D: The Domain Admins group represent the users who have broad administrative rights in a domain. These users are responsible for administration and delegation of authority.

E: By default, any domain user account is automatically added to the Domain Users group.
转载请注明原文地址:https://kaotiyun.com/show/nuhZ777K
0

最新回复(0)