May 7, 2004 at 3:49 pm
I have 1 SQL 2000 std on Win2000 Server (Publisher / distributor) and a subscription on a Win2003 Ser. std (also SQL2000 std)
When I set a new push subscription (using EM) It runs but I get a ststus "Deactivated", and I don't seem to be able to get it going. I am fairly new to this subject - any help?
also when attempting to run a Pull sub from the Win 2003 mach. I get a status 'Never started" on the publisher ? guess the root for both problems is the same?
May 10, 2004 at 8:00 am
This was removed by the editor as SPAM
May 10, 2004 at 11:59 am
was an initial snapshot of the publication generated (yes, even for merge replication)?
May 10, 2004 at 6:24 pm
Yes, it was geneated. I also attempted re-initializing.. no joy
May 10, 2004 at 9:31 pm
Check what user owns the SQL Agent Job for the distribution agent. I have had some issues with the job being owned by a domain login (the person who created the subscription) but when SQL Agent attempts to start the job, it has a problem contacting the domain controller to authenticate the user.
I usually change the owner of the various replication jobs to be "sa".
May 11, 2004 at 1:28 am
Thanks very much, I will
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply