The code you have posted is working correct.

Are you able to login with the credentials using Manamgement Studio?

Does the SQL Error logging contain more information regarding these login failures? Please post all error messages...