2. 计算机
  3. You are the administrator of a new Microsoft Windows 2000 server computer named HQSQL5. HQSQL5 is a member server in your compan

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

admin2009-05-19  18
问题 You are the administrator of a new Microsoft Windows 2000 server computer named HQSQL5. HQSQL5 is a member server in your company’s Windows NT 4.0 domain, which is named HQMAIN.

After installing SQL Server 2000 on HQSQL5, you configure the MSSQLServer service account to use the HQMAIN\sqladmin user account, which is a member of the local administrators group on HQSQL5.

You can use the HQMAIN\sqladmin user account to log on the HQSQL5. However, the MSSQLServer service fails to start. You need to start the service. What should you do?
选项 A、Revoke Log on interactivity rights for the HQMAIN\sqladmin user account.
B、Add the HQMAIN\sqladmin user account to the HQMAIN\Domain Admins group.
C、Select the Password Never Expires check box for the HQMAIN\sqladmin user account.
D、Grant Log on as a service rights to the HQMAIN\sqladmin user account.
答案D
解析 Explanation: On Windows NT and Windows 2000 operating systems, SQL Server 2000 and SQL Server Agent are started and run as Windows services. Windows services require ‘Log on as a service’ rights, which allow a security principal to log on as a service, as a way of establishing a security context. The Local System account on the Windows computer always retains the right to log on as a service. Any service that runs under a separate account must be granted this right.

Incorrect Answers:
A: The log on interactively should only be applied to user accounts that runs services. Revoking it for the HQMAIN\sqladmin would make the MSSQLServer service to start.

B: The Domain Admins global group can represent the users who have broad administrative rights in a domain. Windows 2000 Server places all users with an Administrator account into this group automatically. This group is responsible for administration and delegation of authority. It is therefore not an appropriate group for Windows service.

C: The Password Never Expires check box specifies that he current Windows NT or Windows 2000 user account password does not need to be changed on a regular basis. However, it is only the MSSQLServer service that failed to start therefore the problem is not related to an expired password.
转载请注明原文地址:https://jikaoti.com/ti/vVO7FFFM
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

相关试题推荐
随机试题
最新回复(0)