How to Setup multiple distributors for single publisher db in SQL Server 2014 RRS feed

  • Question

  • Hi,

    I have 2 replications running on the server both of them are using the same source db. How ever I would like to select a different distributor for one of the publication and the other one using the distributor configured in the publisher server. Is that possible in SQL server 2014?

    Thanks & Regards,
    Tuesday, June 12, 2018 1:11 PM


  • This can't be done. Multiple publishers can use different distribution databases on a remote distributor, but you can't configure multiple publications on the same server to use different distribution databases.
    • Marked as answer by AnithaJ Friday, August 21, 2020 5:33 AM
    Tuesday, June 12, 2018 1:17 PM