April 28, 2010 at 3:55 am
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
April 28, 2010 at 9:45 am
Check under which account your Distributor SQL Service and Agents are running.
-Roy
April 28, 2010 at 11:58 am
Your Server name, Your network connectivity or a defined alias is preventing distribution agent to connect.
* Noel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply