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.