problem pulling publication

Author Topic
oleg aga
Member

Joined: 20 Mar 2005
Country:
Posts: 1

Posted: 20 Mar 2005 11:40:47

I have problem using merge replication. I have two PCs 1. Win2003srv with SQL2000 enterprise 2.WinXP Home/Prof with SQL2000 Personal. Win2003 acts as a Distributor and Publisher allowing to pull anonumous subscriptions. When WinXP PC connects to Publisher I am getting some error messages.

Job history as follows:
-Retrieving subscription information

-The subscription has been marked for reinitialization. Reinitialization will occur the next time you synchronize this subscription.

-Category:NULL
Source: Merge Replication Provider
Number: -2147201001
Message: The schema script '\\*****\E$\*******\unc\****-*****-****\20050320073116\Year_1.sch' could not be propagated to the subscriber.

-Category:AGENT
Source: SOME-PC
Number: 0
Message: The process could not read file '\\*****\E$\*******\unc\****-*****-****\20050320073116\Year_1.sch' due to OS error 53.

-The schema script '\\*****\E$\*******\unc\****-*****-****\20050320073116\Year_1.sch' could not be propagated to the subscriber. The step failed.


Replication monitor history:

-The schema script '\\*****\E$\*******\unc\****-*****-****\20050320073116\Year_1.sch' could not be propagated to the subscriber.
Category:Agent
Source: Merge Replicator Provider
Number: -2147201001

Hidden publication share has attributes: Everyone/full control

What's wrong in my setup.
Same setup works when two PCs are WinXP Home/Prof without any problem. Looks like the problem with server PC.

I have problem using merge replication. I have two PCs 1. Win2003srv with SQL2000 enterprise 2.WinXP Home/Prof with SQL2000 Personal. Win2003 acts as a Distributor and Publisher allowing to pull anonumous subscriptions. When WinXP PC connects to Publisher I am getting some error messages.

Job history as follows:
-Retrieving subscription information

-The subscription has been marked for reinitialization. Reinitialization will occur the next time you synchronize this subscription.

-Category:NULL
Source: Merge Replication Provider
Number: -2147201001
Message: The schema script '\\*****\E$\*******\unc\****-*****-****\20050320073116\Year_1.sch' could not be propagated to the subscriber.

-Category:AGENT
Source: SOME-PC
Number: 0
Message: The process could not read file '\\*****\E$\*******\unc\****-*****-****\20050320073116\Year_1.sch' due to OS error 53.

-The schema script '\\*****\E$\*******\unc\****-*****-****\20050320073116\Year_1.sch' could not be propagated to the subscriber. The step failed.


Replication monitor history:

-The schema script '\\*****\E$\*******\unc\****-*****-****\20050320073116\Year_1.sch' could not be propagated to the subscriber.
Category:Agent
Source: Merge Replicator Provider
Number: -2147201001

Hidden publication share has attributes: Everyone/full control

What's wrong in my setup.
Same setup works when two PCs are WinXP Home/Prof without any problem. Looks like the problem with server PC.
Follow us on twitter Subscribe to our RSS feed
Activate your free membership today | Login | Currency