From : http://officenotes.spaces.live.com/blog/cns!43AE5D331F584382!304.entry?sa=89712578
"Login failed for user 'username'. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470)"
"Login failed for user 'username'. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470)"
(a)Expand the SQL Server
(c) Expand Security node
(d) Select the Particular Login (User)
(e) Press right button and select properties of the login
(f) Go to Status table Enble the User