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.