By default SQL Server Accounts in SQL Server 2005 and newer adhere to the Windows domain policy for password expiration. In SSMS right click on the user in question, and select properties and uncheck either the “Enforce password policy” and/or the “Enforce password expiration” checkboxes.
Or change the password for that account, but when it expires again it will start throwing the error again.
Discuss This Question: 1  Reply