The default domain GPO in your company is configured by using the following account
policy settings:
Minimum password length: 8 characters
Maximum password age: 30 days
Enforce password history: 12 passwords remembered
Account lockout threshold: 3 invalid logon attempts
Account lockout duration: 30 minutes
You install Microsoft SQL Server on a computer named Server1 that runs Windows Server
2008 R2. The SQL Server application uses a service account named SQLSrv. The SQLSrv
account has domain user rights.
The SQL Server computer fails after running successfully for several weeks. The SQLSrv
user account is not locked out.

You need to resolve the server failure and prevent recurrence of the failure. Which two
actions should you perform? (Each correct answer presents part of the solution. Choose
two.)

A.
Reset the password of the SQLSrv user account.

B.
Configure the local security policy on Server1 to grant the Logon as a service right on the
SQLSrv user account.

C.
Configure the properties of the SQLSrv account to Password never expires.

D.
Configure the properties of the SQLSrv account to User cannot change password.

E.
Configure the local security policy on Server1 to explicitly grant the SQLSrv user account
the Allow logon locally user right.

Explanation:
Personal comment:
Maximum password age: 30 days
The most probable cause for the malfunction is that the password has expired.
You need to reset the password and set it to never expire.