Many times you have applications that need to have a SQL Server login instead of one that uses Windows authentication. So you create one, and then you try to login using the credentials and you get the dreaded: Login failed for user Error: 18456 error. Below I am going to show you one way that fixes the issue.
Continue reading SQL Server: Login Failed for user Error: 18456
Jim Salasek's SQL Server Blog 