This is unbelievable! There is no way to tell which is because of a password being wrong since there is no state information given. Even your reference for the correct answer shows that State 8
is an incorrect password and State 11
means the account has not been granted access. Error 18456 shows up as State 1
to the client side, no matter what the error state actually was. You need to check the sql errorlog to actually find out what happened and then use this well-known post to find the underlying reason for the login failure:
Someone really needs to start checking these questions before they get posted!