• 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:

    http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

    Someone really needs to start checking these questions before they get posted!