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.
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]