Yes, adding a database with new or different user names (or even users created
in a different order) will affect login-user mapping. That's why Microsoft has a
sp_change_users_login utility.
You can't preserve userids across instances without an extraordinary amount of work
(which has to be done before they first get out of sync).
- V