Msg 15099 Level 16 State 1 Line 1 The MUST_CHANGE option cannot be used when CHECK_EXPIRATION is OFF.
Posted on : 04-06-2012 | By : Devi Prasad | In : Msg 15099
0
Error Message:
Msg 15099, Level 16, State 1, Line 1
The MUST_CHANGE option cannot be used when CHECK_EXPIRATION is OFF.
Fix/resolution:
Add CHECK_EXPIRATION=ON TO the script or remove MUST_CHANGE from the script
Before:
CREATE LOGIN [username] WITH PASSWORD=N'pa@Ssword' MUST_CHANGE
After:
CREATE LOGIN [username] WITH PASSWORD=N'pa@Ssword' MUST_CHANGE, CHECK_EXPIRATION=ON
OR
CREATE LOGIN [username] WITH PASSWORD=N'pa@Ssword' MUST_CHANGE
Reference : Devi Prasad (sqlserverlearner.com)
Do you like my blog?
If you liked reading this blog, please help spread the word by sharing this blog with your friends.
Need Help On SQL Server?
Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.
Tags: Msg 15099, Msg 15099 Level 16, sql server error 15099, The MUST_CHANGE option cannot be used when CHECK_EXPIRATION is OFF
