Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

Can publisher server connected to multiple distributor

Anyone know how could I connect to 2 or more distributor for single publisher? I have an instance of sql server (publisher) with few db and I want it to connect to difference distributor. Currently I only saw one distributor exist and there is no option to create configure another one in EM.

sp_get_distributor only show one as  now.

installed distribution server        distribution db installed is distribution publisher has remote distribution publisher
--------- ------------------------------------------------ ------------------------- ------------------------- -----------------------
1         TSD001\SQL1               0                         0                         0

1 Solution
You can have only one distributor for a given server publications.

The question is why you want two seperate distributor for the same publisher.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now