{"id":242,"date":"2012-06-04T09:24:45","date_gmt":"2012-06-04T09:24:45","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/06\/04\/sql-server-error-15195-the-must_change-option-is-not-supported-by-this-version-of-microsoft-windows\/"},"modified":"2012-06-04T09:24:45","modified_gmt":"2012-06-04T09:24:45","slug":"sql-server-error-15195-the-must_change-option-is-not-supported-by-this-version-of-microsoft-windows","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/06\/04\/sql-server-error-15195-the-must_change-option-is-not-supported-by-this-version-of-microsoft-windows\/","title":{"rendered":"SQL Server error 15195 &#8211; The MUST_CHANGE option is not supported by this version of Microsoft Windows."},"content":{"rendered":"<p><strong>Error Message:<\/strong><br \/>\n<em>The MUST_CHANGE option is not supported by this version of Microsoft Windows.<\/em><\/p>\n<p><strong>Fix\/Resolution:<\/strong><br \/>\nIf you are creating user using the UI then Uncheck <em>User Must Change Password at Next Login <\/em>option as schown below.<\/p>\n<figure id=\"attachment_2631\" aria-describedby=\"caption-attachment-2631\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/sqlserverlearner.com\/wp-content\/uploads\/2012\/06\/Uncheck-User-Must-Change-Password-at-Next-Login.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/sqlserverlearner.com\/wp-content\/uploads\/2012\/06\/Uncheck-User-Must-Change-Password-at-Next-Login-300x269.png\" alt=\"\" title=\"Uncheck User Must Change Password at Next Login\" width=\"300\" height=\"269\" class=\"size-medium wp-image-2631\"><\/a><figcaption id=\"caption-attachment-2631\" class=\"wp-caption-text\">Uncheck User Must Change Password at Next Login<\/figcaption><\/figure>\n<p>If you are using the script to create user then remove the word MUST_CHANGE from the syntax.<br \/>\n[sql]<br \/>\nCREATE LOGIN [username] WITH PASSWORD=N&#8217;pa@Ssword&#8217; MUST_CHANGE, DEFAULT_DATABASE=[master], CHECK_EXPIRATION=ON, CHECK_POLICY=ON<br \/>\n[\/sql]<\/p>\n<p>After:<br \/>\n[sql]<br \/>\nCREATE LOGIN [username] WITH PASSWORD=N&#8217;pa@Ssword&#8217; , DEFAULT_DATABASE=[master], CHECK_EXPIRATION=ON, CHECK_POLICY=ON<br \/>\n[\/sql]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2118],"tags":[2119,2120,2121],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/242"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=242"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/242\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=242"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=242"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}