It appears that that user is a SQL Server user, not a network user.  Your linked tables show Integrated Security, so the user would be trying to connect with their network credentials, not with the "databasetest" account.  You can create ODBC connections using standard SQL Server security, but they are frequently an issue when you have multiple users connecting from different workstations.