Error: 18486 Login failed for user ‘sa’ because the account is currently locked out. The system administrator can unlock it.

here is the fix :

 

ALTER LOGIN sa WITH PASSWORD = ‘yourpass’ UNLOCK ;

GO

Of course you can also disable your policy

ALTER LOGIN sa WITH CHECK_POLICY = OFF;
ALTER LOGIN sa WITH CHECK_POLICY = ON;

Advertisements