You are the database administrator of your company. The network contains an instance of SQL Server 2008. You configure a domain user account that will be used by the SQL Server service for the default instance. After several days, you discover that the SQL Server service is unable to start. You investigate and discover the password 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.
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 the default instance requires the Log on as a service right to start successfully. This user right is automatically granted 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 this user right to the new user account. If the user account that is used by the SQL Server service does not have this user right, an error message stating The service did not start due to a logon failure is displayed. 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 SQL Server service to start successfully. The SQL Server service for the default instance requires the Log on as a service right to start successfully. The Act as part of the operating system right enables a process to impersonate any user without authentication, which provides the process with access to the local resources to which the user has access. The Log on locally right determines which users are allowed to log on interactively to the computer on which this setting is configured. The Impersonate a client after authentication right determines which accounts are allowed to impersonate other accounts.Objective: Installing and Configuring SQL Server 2008 Sub-Objective: Configure SQL Server services.
References: MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > Product Documentation > SQL Server 2008 Books Online > Getting Started Initial Installation > Planning a SQL Server Installation > Setting Up Windows Service Accounts TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > Product Documentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration > Administration: How-to Topics > Managing Services How-to Topics > Managing Services How-to Topics (SQL Server Configuration Manager) > How to: Change the Password of the Accounts Used by SQL Server (SQL Server Configuration Manager)