how to unlock the lockedout login

you might come across 

Login failed for user 'TEST' because the account is currently locked out. The system administrator can unlock it. 
(Microsoft SQL Server, Error: 18486)

use the below query to resolve the issue 


ALTER LOGIN TEST  WITH PASSWORD = 'ABCDE!##'  UNLOCK
















Thanks