When restoring a database from one SS instance to another there is two things I generally do from a script:

sp_changedbowner 'USERNAME'

sp_revokedbaccess 'USERNAME'

sp_grantdbaccess 'USERNAME'

These are needed in order to match the user SIDs for the new instance.