Even if the new server has all the sql logins on it, the SIDs of the users in the database are different, because the logins were created on a different server.

In the attached database, run:

ALTER USER UserName WITH LOGIN = LoginName

for each user associated with a sql login