Strange behavior from MS SQL Server 2005. I "spontaneously" get this error when trying to connect:
Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it. (Microsoft SQL Server, Error: 18486).
After some digging I've found
this useful chain of posts, logged into the server locally and ran the following line:
ALTER LOGIN sa WITH PASSWORD = 'your_password_here' UNLOCK
I suspect what happened was that MS SQL Server decided to lock the sa login after I made a few login attempts with the wrong password. Assuming that's what happened, does anybody know how to change this "lockdown" behavior on behalf of MS SQL Server 2005?