we have 3 publisher databases for each publisher db we have 2 subscription db's with 16 transactional publications in each publisher DB.now i added one more publisher DB with 2 subscription db's but I can not see the subscription on the subscription node and i can see this subscription on the Publisher's Server's Subscription node and replication triggers also not created.Can you please let me know the solution for this?
asked Apr 17, 2012 at 05:58 AM in Default
It looks like the creation didn't run through completely. I suggest recreating the subscription from scratch (drop the existing half-built subscription first).
EDIT (After OP's comment):
You have posted a lot of requests recently about replication, with slightly differing content.
It seems that you are having quite a few issues with replication in general - in particular in this question you seem to be misusing some of the nomenclature for replication.
If I understand you correctly, you have the following:
You want to add a 17th Publication with 2 subscriptions. The publication is created fine, but the creation of the subscription is created without error, but no entry is appearing on the subscriber node.
That to me sounds like you are creating the publication and subscription via scripts and are not running the subscription creation on the subscriber machine (a pull subscription where the distributor runs on the subscriber and not on the publisher).
I suggest you re-try building the publication and subscription using the GUI tools to ensure each step is run correctly.
Also ensure that the accounts used in replication have the required permissions on the subscriber machine.