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

Error Message:
Msg 15195, Level 16, State 1, Line 2
The MUST_CHANGE option is not supported by this version of Microsoft Windows.

Severity level:
16.

Description:
This error message appears when you try to create a login with SQL Server authentication that must change its password upon first connect, but the operating system running SQL Server does not support this setting.

Consequences:
The T-SQL statement can be parsed, but causes the error at runtime.

Resolution:
Errors of the Severity Level 16 are generated by the user and are corrigible by the user. The statement cannot be executed this way. You cannot use the MUST_CHANGE option.

Versions:
This error message was introduced with SQL Server 2005.

Example(s):
USE Master;
CREATE LOGIN MyLogin
 WITH PASSWORD = ‘ABC’
 MUST_CHANGE,
 CHECK_POLICY = OFF,
 CHECK_EXPIRATION = ON;
GO

Remarks:
In the above example we try to create a login with the MUST_CHANGE option set on a Windows XP Profession SP 2 System. Because XP does not support this option, the error is raised.