Microsoft
70-432 · Question #167
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…
The correct answer is D. ALTER LOGIN srpc8521 WITH NO CREDENTIAL. See the full explanation below for the reasoning.
Question
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?
Options
- AALTER LOGIN srpc8521 ENABLE;
- BALTER LOGIN srpc8521 UNLOCK;
- CALTER LOGIN srpc8521 WITH CHECK_EXPIRATION = OFF;
- DALTER LOGIN srpc8521 WITH NO CREDENTIAL;
How the community answered
(25 responses)- A4% (1)
- B8% (2)
- C8% (2)
- D80% (20)
Community Discussion
No community discussion yet for this question.