How to disable SQL server password auto Reset| Disable password expiration on SQL user login

Solution:

1. Open SQL management studio

2. Login with Admin Level account.

3. Security –> Logins

4. Right click the desired login and choose properties

5. Untick enforce password expiration

6. Choose OK

Screen Shot:

Step1:

Step2: