Replication FAILS. URGENT HELP

  • Please, urgent help. We had a lot of problems with replication. At the end, I did sp_removedbreplication @dbname='mydb', and initially seems to work. But, as I change a lot of parameters (i don't remember what), now the situation is that I can create a snapshot and execute it. And it works fine. But, when I create the subscription and try to execute he synchronization, IT FAILS with the message, cannot connect with the Subscriber.

    Thanks a lot.

  • Could you connect to the subscribers? It may be a connection issue.

  • Yes, I can connect fine. Even opening Enterprise Manager I can manage my remote BD.

    Thanks

  • Have you tried dropping the subscribers from the publisher first, and clear the following tables in the database on the subscriber, then recreate the subscription?

    sysmergearticles

    sysmergepublications

    sysmergeschemachange

    sysmergesubscriptions

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply