Using same remote distributor for subscriber

• Bart Lewandowski

  Ten Centuries

  Points: 1099

  More actions

  May 27, 2013 at 3:54 am

  #394852

  Hi,

  Here is a setup that I have now:

  Publisher1 -> RemoteDist1 -> Subscriber1

  Now what we are trying to do:

  Publisher1 -> RemoteDist1 -> Subscriber1 (New Publisher) -> RemoteDist1-> Subscriber2

  Did anyone know about restrictions using same distributor server for subscriber that will become a new publisher?

  When trying to configure a new publisher and specifying the remote distributor we are getting error when specifying distributor admin password, that password is incorrect. We are 100% that password is correct and distributor_admin have admin permissions on distributor etc.

  Thanks

  BartL
  Replication Blog