all groups > sql server replication > july 2005 >
You're in the

sql server replication

group:

Distribution Agent TimeOut


Distribution Agent TimeOut SQL Replication Guy
7/25/2005 10:02:01 AM
sql server replication:
I have setup pull transactional replication with multiple publications and
distribution agents.

One of my distribution agent always says the following error--
--
Timeout expired
(Source: ODBC SQL Server Driver (ODBC); Error number: S1T00)
--

while other agents are executed just fine..

any suggestions..??

Re: Distribution Agent TimeOut Hilary Cotter
7/25/2005 4:43:12 PM
bump up LoginTimeout and QueryTimeout to 120.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"SQL Replication Guy" <SQLReplicationGuy@discussions.microsoft.com> wrote in
message news:65DC7C0C-6149-4DB0-8C28-06DAC9EAAA59@microsoft.com...
[quoted text, click to view]

AddThis Social Bookmark Button