Error Message:
The MUST_CHANGE option is not supported by this version of Microsoft Windows.

Fix/Resolution:
If you are creating user using the UI then Uncheck User Must Change Password at Next Login option as schown below.

Uncheck User Must Change Password at Next Login

If you are using the script to create user then remove the word MUST_CHANGE from the syntax.
[sql]
CREATE LOGIN [username] WITH PASSWORD=N’pa@Ssword’ MUST_CHANGE, DEFAULT_DATABASE=[master], CHECK_EXPIRATION=ON, CHECK_POLICY=ON
[/sql]

After:
[sql]
CREATE LOGIN [username] WITH PASSWORD=N’pa@Ssword’ , DEFAULT_DATABASE=[master], CHECK_EXPIRATION=ON, CHECK_POLICY=ON
[/sql]

Leave a Reply

Your email address will not be published. Required fields are marked *