Problem:

Connection to database unsuccessful,(Username)-Account is currently lockout

Solution:

Go to Start -> All programs -> Microsoft Sql Server 2005 -> SQL Server Management Studio 
Go to security -> log-in ,Right click on log-in name and click on priorities , Click on Status 
SQL server authentication: Flag off, Login is lock out.