USEFUL SITES :
Write for Us
Error Message:Msg 15195, Level 16, State 1, Line 2The 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.