{"id":243,"date":"2012-06-04T09:30:41","date_gmt":"2012-06-04T09:30:41","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/06\/04\/msg-15099-level-16-state-1-line-1-the-must_change-option-cannot-be-used-when-check_expiration-is-off\/"},"modified":"2012-06-04T09:30:41","modified_gmt":"2012-06-04T09:30:41","slug":"msg-15099-level-16-state-1-line-1-the-must_change-option-cannot-be-used-when-check_expiration-is-off","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/06\/04\/msg-15099-level-16-state-1-line-1-the-must_change-option-cannot-be-used-when-check_expiration-is-off\/","title":{"rendered":"Msg 15099 Level 16 State 1 Line 1 The MUST_CHANGE option cannot be used when CHECK_EXPIRATION is OFF."},"content":{"rendered":"<p><strong>Error Message:<\/strong><br \/>\n<font color=\"red\"><br \/>\nMsg 15099, Level 16, State 1, Line 1<br \/>\nThe MUST_CHANGE option cannot be used when CHECK_EXPIRATION is OFF.<br \/>\n<\/font><\/p>\n<p><strong>Fix\/resolution:<\/strong><br \/>\nAdd CHECK_EXPIRATION=ON TO the script<strong> or <\/strong>remove MUST_CHANGE from the script<br \/>\n<em>Before:<\/em><br \/>\n[sql]<br \/>\nCREATE LOGIN [username] WITH PASSWORD=N&#8217;pa@Ssword&#8217; MUST_CHANGE<br \/>\n[\/sql]<\/p>\n<p><em>After:<\/em>[sql]<br \/>\nCREATE LOGIN [username] WITH PASSWORD=N&#8217;pa@Ssword&#8217; MUST_CHANGE, CHECK_EXPIRATION=ON<br \/>\n[\/sql]<\/p>\n<p>OR<\/p>\n<p>[sql]<br \/>\nCREATE LOGIN [username] WITH PASSWORD=N&#8217;pa@Ssword&#8217; MUST_CHANGE<br \/>\n[\/sql]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Error Message: Msg 15099, Level 16, State 1, Line 1 The MUST_CHANGE option cannot be used when CHECK_EXPIRATION is OFF. Fix\/resolution: Add CHECK_EXPIRATION=ON TO the script or remove MUST_CHANGE from the script Before: [sql] CREATE LOGIN [username] WITH PASSWORD=N&#8217;pa@Ssword&#8217; MUST_CHANGE [\/sql] After:[sql] CREATE LOGIN [username] WITH PASSWORD=N&#8217;pa@Ssword&#8217; MUST_CHANGE, CHECK_EXPIRATION=ON [\/sql] OR [sql] CREATE LOGIN [username]&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2122],"tags":[2123,2124,2125,2126],"class_list":["post-243","post","type-post","status-publish","format-standard","hentry","category-msg-15099","tag-msg-15099","tag-msg-15099-level-16","tag-sql-server-error-15099","tag-the-must_change-option-cannot-be-used-when-check_expiration-is-off"],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/243","targetHints":{"allow":["GET"]}}],"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=243"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/243\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}