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.
  • Share/Bookmark

1 Comment

ClaudioFebruary 6th, 2009 at 12:38 am

Gracias…. Thank you…. :)

Leave a comment

Your comment