You administer a SQL Server 2008 instance.
A user named Julie reports repeated failed connections because of incorrect password
usage for the login name srpc8521. Julie has been able to successfully login using this
account in the past. Julie then recalls the correct password. However, her connection is still
denied.
You need to enable the SQL Server login.
Which Transact-SQL statement should you use?
A.
ALTER LOGIN srpc8521 ENABLE;
B.
ALTER LOGIN srpc8521 UNLOCK;
C.
ALTER LOGIN srpc8521 WITH CHECK_EXPIRATION = OFF;
D.
ALTER LOGIN srpc8521 WITH NO CREDENTIAL;