SQL 2005SP3 (I am told this should work on SQL2008 also but I have not confirmed)
detach the database from server 1
attach the database to server 2
recreate the user at the SQL level – then get denied because the user already exists inside the database. Ooops!
Flail. Repeat. LOL.
Seriously, for those of us who are not SQL admins, this stuff is a different language. Some cursory gooogly work revealed my total lack of sql syntax knowledge. A call to an SQL programmer-now-IT-Manager friend of mine gave me some good insight, and we (he) figured out the following fix.
exec sp_change_users_login 'update_one', 'nameinsidedatabaseaccount', 'nameinsidesqlsecurityaccount'