I have got the same problem as well

When I connect using the username/password in SQLServer Management Studio it works fine

When I use the same username/password in an app to connect to the server I get the error message

SqlConnection connection = new SqlConnection ("server=localhost; uid=test; pwd=test; database=test");

connection.Open();

I have the server configured for mixed mode authentication

Any help would be appreciated.