Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Replication - hangs at connection to publisher

Author  Topic 

wolfgang2010
Starting Member

6 Posts

Posted - 2010-02-08 : 09:10:49
I'm using a much older version of sql server but I wanted to post here too because it's the correct forum for replication..

We changed ISP's which should NOT make a difference here but it's the only thing I can think of that could have caused this.

My replication hangs on connection to publisher..

If I disable and stop the agent. Wait a few minutes, it will connect and do it's thing. Sometimes it will then work on the schedule (Every 20 minutes).. but not for too long it then goes back to connection to publisher.. then of course it will fail sometime soon after.

This has been in place for years and i'm not sure how to fix this!! Help :)
   

- Advertisement -