Passphrase lost after moving users

I know something like this was addressed before on this forum but I am unable to locate it at all...
Anyone know the solution ?
Problem :
After you move databases to a new server, users may not be able to log in to the new server:
Used DTS ...
Thanks..checkout sp_change_users_login in BOL

sp_change_users_login [ @.Action = ] 'action'
[ , [ @.UserNamePattern = ] 'user' ]
[ , [ @.LoginName = ] 'login' ]
[ , [ @.Password = ] 'password' ]