msg: 18486
Login failed for user ‘sa’ because the account is currently locked out. The system administrator can unlock it.
2) If this is a one-time issue, enable “sa” login WITH changing password of “sa” login.
ALTER LOGIN sa WITH PASSWORD = 'yourpass' UNLOCK ;
GO
3) If this is a one-time issue, enable “sa” login WITHOUT changing password of “sa” login.
ALTER LOGIN sa WITH CHECK_POLICY = OFF;
ALTER LOGIN sa WITH CHECK_POLICY = ON;
GO
No comments:
Post a Comment