That's because each login on a server has a sid that links them to the database user. When you restore the database from a different server, its sid is different from the login on your server and it can't link the 2. Run this to fix it:

USE databaseName

GO

ALTER USER username WITH LOGIN = loginName

That will change the sid of the database user to match with the login.