Script out the users from Master. Run them into the new server. Then restore the DB.

Orphaned users can be fixed with SP_change_Users_login

mpv-1060508 (4/9/2009)

---

Is there an update to this procedure? The table master.dbo.spt_datatype_info does not exist, or is not visible in 2005.

I get the following error messages:

Msg 208, Level 16, State...

Can this be used over a linked server as well. I have 2 tables on 2 different servers and want to compare them.