{"id":2609,"date":"2014-01-14T10:35:48","date_gmt":"2014-01-14T00:35:48","guid":{"rendered":"http:\/\/support.cybersecure.com\/?p=2609"},"modified":"2014-01-14T10:36:13","modified_gmt":"2014-01-14T00:36:13","slug":"disable-password-expiry-on-sql-user-login","status":"publish","type":"post","link":"http:\/\/support.cybersecure.com\/?p=2609","title":{"rendered":"Disable password expiration on SQL user login"},"content":{"rendered":"<ol>\n<li>Open SQL management studio<\/li>\n<li>Login with an appropriate admin-level account (using either Windows or SQL authentication)<\/li>\n<li>Expand Security &#8211; Logins<\/li>\n<li>Right click the desired login and choose properties<\/li>\n<li>Untick enforce password expiration<br \/>\n<a href=\"http:\/\/support.cybersecure.com\/wp-content\/uploads\/2014\/01\/sql-studio-user-properties-password-expiry1.png\"><img loading=\"lazy\" class=\"alignnone size-medium wp-image-2611\" title=\"sql-studio-user-properties-password-expiry\" src=\"http:\/\/support.cybersecure.com\/wp-content\/uploads\/2014\/01\/sql-studio-user-properties-password-expiry1-300x267.png\" alt=\"\" width=\"300\" height=\"267\" srcset=\"http:\/\/support.cybersecure.com\/wp-content\/uploads\/2014\/01\/sql-studio-user-properties-password-expiry1-300x267.png 300w, http:\/\/support.cybersecure.com\/wp-content\/uploads\/2014\/01\/sql-studio-user-properties-password-expiry1.png 724w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<li>Choose OK<\/li>\n<li>You can attempt to login to SQL management studio with those login credentials to confirm the account is working correctly.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Open SQL management studio Login with an appropriate admin-level account (using either Windows or SQL authentication) Expand Security &#8211; Logins Right click the desired login and choose properties Untick enforce password expiration Choose OK You can attempt to login to &hellip; <a href=\"http:\/\/support.cybersecure.com\/?p=2609\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[],"_links":{"self":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/2609"}],"collection":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2609"}],"version-history":[{"count":2,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/2609\/revisions"}],"predecessor-version":[{"id":2613,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/2609\/revisions\/2613"}],"wp:attachment":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2609"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}