Home > IT Answers > SQL Server > I am using SQL Server 2005, I keep receiving the following error message:The following error keeps occurring every 30 minutes in error logs. “The specified user account has expired”.
Tizi
30 pts.
 I am using SQL Server 2005, I keep receiving the following error message:The following error keeps occurring every 30 minutes in error logs. “The specified user account has expired”.
SQL Server 2005, SQL Server errors
I am using SQL Server 2005, I keep receiving the following error message: The following error keeps occurring every 30 minutes in error logs. "The specified user account has expired". Has anyone ever come across this error message?

Software/Hardware used:
ASKED: June 20, 2008  2:42 PM
UPDATED: June 23, 2008  6:47 AM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  June 23, 2008  6:47 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.