I tried to set up 3 SQL instances, one publisher 2 subscribers, to replicate data between them.
I did it using the GUI wizard and all went fine in the Publisher: my publication appears under "Local Publications" and if I expand it, it lists the 2 subscriptions of the other 2 instances.
But in the 2 instances, the subscription does not appear under "Local Subscription". If I try to do it again, it tells me the subscription already exists..
How can I get the 2 subscribers to appear under 'Local Subscription' and make transactional replication work?