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 isnot
locked out.
You need to resolve the server failure and prevent recurrence of the failure. Which two actions shouldyou
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 Serverl togrant the Logon as a service right on the SQLSrv user
account.

C.
Configure the properties of the SQLSrv account toPassword never expires.

D.
Configure the properties of the SQLSrv account toUser cannot change password.

E.
Configure the local security policy on Serverl toexplicitly grant the SQLSrv user account the Allowlogon
locally user right.