Example: Using the Site User Map Tab

You have three sites that are sharing data through non-transactional replication: OHIO, ARIZ, and MICH. While logged into the OHIO site, set up site user maps in the Sites or Sites/Entities form for ARIZ and MICH, with the From Site set to OHIO and the User set to repl_user. Tthis user is defined in all three sites. In ARIZ, set up site user maps connecting to OHIO and to MICH. In MICH, set up site user maps connecting to ARIZ and to OHIO.

In ARIZ, the Site User Maps setup looks like this for the three site records in the Sites or Sites/Entities form:

Site Record From Site User Name
ARIZ (blank) (blank)
MICH ARIZ repl_user
OHIO ARIZ repl_user

In OHIO, the Site User Maps setup looks like this for the three site records in the Sites or Sites/Entities form:

Site Record From Site User Name
ARIZ OHIO repl_user
MICH OHIO repl_user
OHIO (blank) (blank)

In MICH, the Site User Maps setup looks like this for the three site records in the Sites or Sites/Entities form:

Site Record From Site User Name
ARIZ MICH repl_user
MICH (blank) (blank)
OHIO MICH repl_user