It will look in the remote database for the same user used on the local database.

That user should exist on both databases.