replication failed after restart

Hi..

I've 3 pc that have MS SQL 2000 database installed in it and connected to main server through merge replication.

At first it run fine all the time. But now, it doesn't. It's happen when the pc have to restart every night. When i come to the office and check resplication status it return failed. I try to manually start synchronize but it failed too. I've to restart the pc all over again untill it ok.

I hope some body out there can explain something to me and how to overcome the problem...

If the PC restarts during the initialization then it will fail and you will have to start initialization again.

It would be helpful to know the error messages.

Martin

|||

the error message is

the process could not connect to subscriber

|||

Can you confirm that the subscribers are up and running? After a reboot are the SQL Services all started and the databases available?

|||yes...|||

Instead of restarting the pc, did you try connecting to the subscriber via isqlw, osql.exe or some other client tool with the same credentials that the merge agent uses? If that also fails then it's not replication.