70-450 · Question #140
Your manager is trying to create a new SQL login using a T-SQL script. This is the command that he is trying to run: CREATE LOGIN users\temp1 FROM WINDOWS MUST CHANGE However, the command fails when…
The correct answer is B. He can't use MUST CHANGE with a windows login. The MUST CHANGE argument applies to SQL Server logins only. If this option is included, SQL Server prompts the user for a new password the first time the new login is used.
Question
Your manager is trying to create a new SQL login using a T-SQL script. This is the command that he is trying to run:
CREATE LOGIN users\temp1 FROM WINDOWS MUST CHANGE However, the command fails when he tries to run it in SQL Management Studio. What is wrong with his SQL statement?
Options
- AHe needs to use WITH SUBJECT as well
- BHe can't use MUST CHANGE with a windows login
- CHe needs to use CHECK POLICY = ON
- DHe needs to use the HASHED argument for windows logins
How the community answered
(27 responses)- A7% (2)
- B74% (20)
- C4% (1)
- D15% (4)
Explanation
The MUST CHANGE argument applies to SQL Server logins only. If this option is included, SQL Server prompts the user for a new password the first time the new login is used.
Topics
Community Discussion
No community discussion yet for this question.