Very useful script to map users to server logins

sp_change_users_login 'update_one','username','password'

Go to MSDN for more info