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 for ARIZ and MICH, with the From Site set to OHIO and the user set to repl_user (this 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 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 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 form:
| Site Record | From Site | User Name |
|---|---|---|
| ARIZ | MICH | repl_user |
| MICH | (blank) | (blank) |
| OHIO | MICH | repl_user |