Results 1 to 3 of 3
  1. #1
    Join Date
    May 2009

    Unanswered: The merge process could not initialize the subscription

    I want to set up a merge replication in SQL server 2000 and recieve this error message:

    The merge process could not initialize the subscription.
    (Source: Merge Replication Provider (Agent); Error number:
    You do not have the required permissions to complete the operation.
    (Source: FS14 (Data source); Error number: 14126)

    Does anyone have any idea what the problem is? The merge agent in
    publication has admin on both servers.
    Thank you very much in advance.


  2. #2
    Join Date
    Jun 2009
    CA, USA
    Make sure you can connect to these servers from each other using the account you are using.
    Also create a linked server and see you can access it...
    SQL Server MVP

  3. #3
    Join Date
    May 2009


    Thank you for your response.
    I can login to each server from other server using the the account that I'm using.
    However, I cannot create link servers because they are already remote servers of each other.

    There also something else you may want to know:
    FS14 is the subscriber.
    And it seems that there is something wrong about it (FS14) and i'm not so sure.
    I can create merge replication successfully between this publisher and any other servers and test servers. I also can create successfully snapshot replication between this publisher and FS14.
    However, I cannot create merge replication between any publisher with FS14.
    I cannot create any publication in this FS14 either.
    Here the error that I got when trying to create a publication in FS14:
    SQL server enterprise manager cannot create publication "test" from database "test". Error 2758: RAISERROR cannot locate entry for error 21423 in sysmessages.
    Someone told me that is because I'm using SQl server 2000 SP3 and that is a bug in SP3. However, I install SQl server 2000 SP3 in a test computer and the merge replication was created successful with this test server. I also can create a publication with this test server without any problem.

    If you can understand why, please let me know.
    Thank you very much.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts