在登入 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;
沒有留言:
張貼留言