Clever Geek Handbook

Unexpiring expired SQL Server login password (password cannot be changed)

I have a SQL Login Server whose password has expired. Unfortunately this password is required as we use it through Dev Machines to test applications.

I cannot change this password, but I need not to use it.

The error I receive is: Error 28000 Login failed for user "Username". Reason: The password has expired.

I am using SQL Server 2014. The Use Password Policy box is unchecked.

+3


source to share


2 answers


Log in as a system administrator. Change your password to something else. Make sure the password policy is disabled, and then change the password to the original password.



+6


source


Right click on "Username" and select "Properties"

You can find "Enforce password expiration" in the login properties window which needs to be cleared.



enter image description here

+13


source






More articles:


All Articles