don't mess with your users
If you get an error related to your user after restoring , mirroring db. etc. Run this: sp_change_users_login 'auto_fix', N'XXXXXX' where XXXXXX= your username, run this under the DB which that user belongs.
I am blogging here some stuff that I find interesting.