You are the database administrator of your company. The network contains an instance of SQL Server 2008. Youconfigure a domain user account that will be used by the SQL Server service for the default instance. Afterseveral days, you discover that the SQL Server service is unable to start. You investigate and discover thepassword for the domain account has expired. To avoid this problem in the future, you create a new user account that will be used by the SQL Server service.The user account’s password does not expire. What should you do next to ensure that the SQL Server service starts successfully?
A.
Grant the new user account the Act as part of the operating system right.
B.
Grant the new user account the Log on locally right.
C.
Grant the new user account the Log on as a service right.
D.
Grant the new user account the Impersonate a client after authentication right.
Explanation:
You should grant the new user account the Log on as a service right. The SQL Server service account for thedefault instance requires the Log on as a service
right to start successfully. This user right is automaticallygranted to the user account that you configure for the SQL Server service during SQL Server setup. When you
configure a new user account that will be used by the SQL Server service, you must ensure that you grant thisuser right to the new user account. If the user account that is used by the SQL Server service does not have thisuser right, an error message stating The service did not start due to a logon failure isdisplayed. You should not grant the new user account the Act as part of the operating system , Log on locally , or Impersonate a client after authentication rights because granting any of these rights will not enable the SQLServer service to start successfully. The SQL Server service for the default instance requires the Log on as aservice right to start successfully. The Act as part of the operating system right enables a process toimpersonate any user without authentication, which provides the process with access to the local resources towhich the user has access. The Log on locally right determines which users are allowed to log on interactively tothe computer on which this setting is configured. The Impersonate a client after authentication right determineswhich accounts are allowed to impersonate other accounts.Objective:
Installing and Configuring SQL Server 2008Sub-Objective:
Configure SQL Server services.References:
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Getting Started Initial Installation > Planning a SQL ServerInstallation > Setting Up Windows Service Accounts TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration >Administration: How-to Topics > Managing Services How-to Topics > Managing Services How-to Topics (SQLServer Configuration Manager) > How to: Change the Password of the Accounts Used by SQL Server (SQLServer Configuration Manager)