Merge replication

  • 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

  • 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