What could cause the 'sa' account to be locked?

Question

Grade: Education Subject: Support
What could cause the 'sa' account to be locked?
Asked by:
47 Viewed 47 Answers

Answer (47)

Best Answer
(383)
The 'sa' account can be locked due to multiple failed login attempts. SQL Server implements security measures to prevent brute-force attacks. The number of failed attempts before lockout is configurable. You can check the failed login attempts in the SQL Server error log. Unlocking typically requires connecting in single-user mode as described in the password reset instructions.