Login failed for user "username"

I ran into the login failed for user "username" again. This time it was different from what I had faced the first time around.

My package uses config file to get the sql credentials. When I have the package open in my IDE and add another parameter to the file it wipes out the previously saved password. So now when I try to execute the package from my IDE to test the changes, I get this dB login failure message.

What threw me off was I was looking at the connection defined in the package designer and all seemed well.

So if this happens again, you need to take a look again in the config file to check if the password value is still there.