Question
What could cause the 'sa' account to be locked?
Asked by: USER4768
47 Viewed
47 Answers
Answer (47)
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.