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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 problem pulling subscription

Author  Topic 

oleg_aga
Starting Member

2 Posts

Posted - 2005-03-20 : 04:46:02
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.
   

- Advertisement -