Disable password expiration on SQL user login

  1. Open SQL management studio
  2. Login with an appropriate admin-level account (using either Windows or SQL authentication)
  3. Expand Security – Logins
  4. Right click the desired login and choose properties
  5. Untick enforce password expiration
  6. Choose OK
  7. You can attempt to login to SQL management studio with those login credentials to confirm the account is working correctly.