Reconnecting orphaned users
If you are restoring a SQL Server database that has user IDs in it between machines, the user IDs from the source machine won't match the destination machine. As a result, you need to correct these “orphans” using this little bit of T-SQL code:
EXEC sp_change_users_login 'Report' -- list orphan users.
EXEC sp_change_users_login 'Auto_fix', 'username' -- autocorrect the orphan user .
EXEC sp_change_users_login 'Report' -- list orphan users to verify that they are no longer orphans.
Tag(s): SQL Server | T-SQL