Unexpiring an expired SQL Server Login password (Password cannot be changed)

Question

I have a SQL server Login which password has recently expired. Unfortunately this password is necessary as we use it across Dev Machines for application testing purposes.

I CAN'T change this password, but I need to unexpire it.

The error I am getting is : Error 28000 Login failed for user 'Username'. Reason: The password of the account has expired.

I am using SQL Server 2014. The 'Enforce Password Policy' box is not ticked.

Answer 1

Right click 'Username' and go to Properties

You can find 'Enforce password expiration' on login properties window, which needs to be unchecked.

Answer 2

Log in as a system administrator. Change the password to something else. Make sure enforce password policy is off and then change the password back to the original password.