If you are trying to login into a MSSQL database using a SQL account code (SQL server authentication) and not a windows account and are getting this error when you are sure the account and password are correct; try checking the 'Server Authentication' setting on the server and make sure it allows both types of access.
