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](https://sqlserverlearner.com/wp-content/uploads/2012/06/Uncheck-User-Must-Change-Password-at-Next-Login-300x269.png)
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]