SQL Server 2005: The password of the account must be changed

Run the following SQL statements for a quick fix to this issue:

ALTER LOGIN UserLogin WITH PASSWORD='password' UNLOCK
ALTER LOGIN UserLogin WITH CHECK_EXPIRATION = OFF
ALTER LOGIN UserLogin WITH CHECK_POLICY = OFF

p.
This should stop that error from showing again.