We have two separate production db servers whose only difference is data content. We are trying to publish the data from each server to a single separate distribution server (separate distrib dbs) and then replicate all the data to tables named by server on a third remote subscriber box.
We were successful at setting up the first distributor, publication and subscription using t-rep. However, when setting up the second server publication and subscription the new one is taking over and the first one stops running.
What am I doing wrong?