Login SQL Error–18486

在登入 SQL 資料庫時,發生系統報錯誤訊息,
Error: 18486 Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it.


錯誤排除:
方法ALTER LOGIN sa WITH PASSWORD = ‘yourpass’ UNLOCK;
GO


當然,你可以修正系統 Policy 設定,避免日後再發生此事。
ALTER LOGIN sa WITH CHECK_POLICY = OFF;
ALTER LOGIN sa WITH CHECK_POLICY = ON;

沒有留言: