Transfer Login

If you need to create a set of SQL Server logon credentials on a second server that match the logon credentials of a primary server, simply creating a user with the same name will most likely not work because the SID for the logon will be different between the two servers.

To handle this situation, you need to copy the original logon, including the SID, to the new server.

Microsoft Support explains how, and provides a pair of stored procedures at this URL:

http://support.microsoft.com/kb/918992/

NOTE: I have not tested this process, so this posting may need to be modified.