You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. AIOTestKing A replicates with other SQL Server computers and manages multiserver automation jobs. It also exports data to staging databases for export to a data warehouse. After a few months without incident, AIOTestKing A fails to start after a reboot.
You review the security log, which returns the results that the Security Log Results exhibit shows.
You then review an individual audit entry, which the Individual Audit Entry exhibit shows.
The Default Domain Group Policy object (GPO) is configured with a Password Policy and Account Lockout Policy as shown in the following table.
You need to ensure that AIOTestKing A runs properly. What should you do?
A.
Unlock the AIOTestKing \sqlsrvc account. Then, configure the account with a strong password. Configure the SQL Server services to use the new account password.
B.
Delete the current AIOTestKing \sqlsrvc account. Then, create a new AIOTestKing \sqlsrvc account and ensure a strong password. Finally, configure the account so that users cannot change the password. Configure the SQL Server services to use the new account password.
C.
Configure the AIOTestKing \sqlsrvc account as a member of the local administrators group on AIOTestKing A. Configure the SQL Server services to use the new account password.
D.
Enable the AIOTestKing \sqlsrvc account. Then, change the password to a strong one.
Finally, configure the account so that users cannot change the password. Configure the SQL Server services to use the new account password.