Monday, January 25, 2016

Unlock SQL login/User with out Resetting Password


 Alter login [XYZ] with CHECK_POLICY = OFF

go

Alter login [XYZ] with CHECK_POLICY = ON

go
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...