Wednesday, March 7, 2012

Publisher keeps trying to connect to subscriber

hi,

I manually changed a value in a table that makes part of the Replication and after that the sync failed on the procedure that updates the table on the subscriber.

So I manually re-start the sync. But for some reason it keeps trying to reconnect to the subscriber.
If I try to delete the subscriber to push it again, it locks.

I went to the Agent History, it showed the error "The process could not connect to Subscriber"
ODBC SQL SERVER DRIVER (number 08001)

I checked the SQL on the subscriber and it's running.
Does anybody has an idea of what I could do ?

Thanks !Before somebody try to answer, I got the replication running again.
I STOPPED the Sql Server at the subscriber and Re-started it.

things looks fine now.

Renata

No comments:

Post a Comment