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)  syn error show can't connect Publisher SQL 2000

Author  Topic  tmmomdy Starting Member 1 Post Posted - 2010-04-26 : 06:39:26 Hi Everyone, When I create replica (Pull) between SQL2000 Server (Publisher) and SQL 2005 (Subscriber), Name of Publisher: MBC-SERVER\MBCSERV Name of Subscirber: MainDS The first I got this Log ++++++++++++++++++++++++++++++++++++++++ Date 4/26/2010 4:54:40 PM Log Job History (MBC-SERVER\MBCSERV-YFD0910-AccSalesData-MAINDS-MBCYFD-3F51A8D2-37CD-4C75-BC35-BE6083345DE2) Step ID 1 Server MAINDS Job Name MBC-SERVER\MBCSERV-YFD0910-AccSalesData-MAINDS-MBCYFD-3F51A8D2-37CD-4C75-BC35-BE6083345DE2 Step Name Run agent. Duration 00:00:00 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message The replication agent has been successfully started. See the Replication Monitor for more information. +++++++++++++++++++++++++++++++++++++++++++++++++++++ And a few second later, I got this log.. +++++++++++++++++++++++++++++++++++++++++++++++++++++ Step ID 1 Server MAINDS Job Name MBC-SERVER\MBCSERV-YFD0910-AccSalesData-MAINDS-MBCYFD-3F51A8D2-37CD-4C75-BC35-BE6083345DE2 Step Name Run agent. Duration 00:00:21 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message 2010-04-26 10:24:40.827 User-specified agent parameter values: -Publisher MBC-SERVER\MBCSERVER -PublisherDB YFD0910 -Publication AccSalesData -Distributor MBC-SERVER\MBCSERVER -SubscriptionType 1 -Subscriber MAINDS -SubscriberSecurityMode 1 -SubscriberDB MBCYFD -Continuous -XJOBID 0x9824737745C17C4BAC259438A2F57117 -XJOBNAME MBC-SERVER\MBCSERV-YFD0910-AccSalesData-MAINDS-MBCYFD-3F51A8D2-37CD-4C75-BC35-BE6083345DE2 -XSTEPID 1 -XSUBSYSTEM Distribution -XSERVER MAINDS -XCMDLINE 0 -XCancelEventHandle 00000454 2010-04-26 10:24:40.827 Startup Delay: 5164 (msecs) 2010-04-26 10:24:45.999 Connecting to Subscriber 'MAINDS' 2010-04-26 10:24:46.139 Connecting to Distributor 'MBC-SERVER\MBCSERVER' 2010-04-26 10:25:01.656 Agent message code 20084. The process could not connect to Distributor 'MBC-SERVER\MBCSERVER'. 2010-04-26 10:25:01.687 The agent failed with a 'Retry' status. Try to run the agent at a later time. +++++++++++++++++++++++++++++++++++++++++++++++++++++ Please advice me how to solve the error. Thank Victor