In my environment, there is a replication configured by using the same server (Assume, Server A) as a distributor.
Now i need to create new replication as like before ,but this time I'm planning to create the distributor in a stand alone server (Assume Server D).
But, while creating the subscription , it won't detecting the Server D for distributor .
It consider the same server distributor which is already configured.
Note: Configured distributor in Server D and selected a publisher as Server A
My question is , Can't we create mutiple distributors in different servers?