A common problem when restoring databases is making orphans of users. Here's a quick fix.
Because SQL Server manages SIDs for any user logging into SQL Server, you risk "orphaning" users when you do a restore. It's a common problem and here's why.
The article continues at