the jackol’s den

27 April 2008

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

Posted by Mikhail Esteves under: Tips; Windows .

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.

Leave a Reply

Name

Mail (will not be published)

Website