| Tim S via SQLMonster.com 2005-09-13, 11:23 am |
| I have two SQL2000 servers using a PUSH Transactional replication and for ONE
publication I recieve the following error when the distribution agent is
started..
Timeout expired
(Source: DENVER-BABYSQL (ODBC); Error number: S1T00)
When you start the agent, it goes to the "Connecting to SERVERNAME" message,
and then eventually times out. I have created a new profile for the agent
and increased the timeout values and other suggestions for similar posts.
I have another Trans_repl task created for the same DB with different tables,
and if I stop the first job from running, this other one will always connect
and replicate. I have tried reinitializing the subscription, but that
doesn't work either. It dies on the initial connection, so sending a new
snap never occurs. I also have another trans_repl task for a different DB
going to the same server that always connects and runs fine.
Any new suggestions?
|