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.




Your Ad Here


Tags: , , ,