December 3, 2008 at 12:52 pm
Hi,
I am working on the Merge Replication between two server(both SQLServer-2005, on windows XP).
i) On one server , I have created the Publication (publisher and distributor)
ii) On second server,I have created the Pull Subscriber
iii) When i went to View the Synchronization status, it says
the schema script 'snapshot.pre' could not be propagated to the subscriber
FYI
i) I am using 'sa' accounts on both the Server to log on
Is there a way I can get this working. Or is there a better work around to achieve merge replication.
I would really appreiciate if some one can come up with an idea or may be the solution to this problem.
Thanks
Gaurav
December 3, 2008 at 8:01 pm
This is probably occurring because the distribution agent (which is running on the subscriber) does not have permission to access the folder on the publisher that contains the snapshot.
The distribution abent is probably running as the same account that you have configured SQL Server Agent to use on the subscriber. This account needs permission to read from the snapshot folder on the publisher.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply