Login failed for User 18456 State 5. User id works on other machines
According to Microsoft documentation it could be:


  The error reason An attempt to login using SQL authentication failed.
  Server is configured for Windows authentication only. can be returned
  in the following situations.
  
  
  When the server is configured for mixed mode authentication, and an ODBC connection uses the TCP protocol, and the connection does not
  explicitly specify that the connection should use a trusted
  connection.
  When the server is configured for mixed mode authentication, and an ODBC connection uses named pipes, and the credentials the client
  used to open the named pipe are used to automatically impersonate the
  user, and the connection does not explicitly specify that the
  connection should use a trusted connection.
  
  
  To resolve this issue, include TRUSTED_CONNECTION = TRUE in the
  connection string.