none
The Merger Process could not connect to the Publisher SERVER\Instance:DATABASE.

    問題

  • There are two servers. Server 1 is the Publisher, and Server 2 is the subscriber. Replication has been working for the past two weeks. I began seeing the error last week.  Can someone help me?

    Command attempted:

    {call sp_MSensure_single_instance (N'SERVER1\AUTODESKVA-KnowledgeVaultMaster-ADMS_KnowledgeVaultMa-Server2\AUTODESKVAU-9', 4)}

    Error messages:

    <dir>

    The merge process could not connect to the Publisher 'SERVER1\AUTODESKVAULT:KnowledgeVaultMaster'. Check to ensure that the server is running. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199368)
    Get help: http://help/MSSQL_REPL-21471993

    </dir>

    2012年4月24日 下午 09:40

所有回覆

  • Is this happening at random?

    There should be some additional details in the verbose agent log.  Add the parameters -OutputVerboseLevel 4 -Output C:\TEMP\mergeagent.log to the Merge Agent job step.  Restart the Merge Agent and capture the error in the verbose log.

    I suspect it is either a permissions or a network related issue.


    Brandon Williams (blog | linkedin)

    2012年4月25日 上午 01:19
  • Sorry I am new to sql server and this is a bit over my head. I went to the jobs monitor for the problem database and i add the ending of the run agent. I have created a log if this is correct, but it i had to change the error to outputverboselevel 2. I don't see any errors, anything else i should be looking for.
    2012年4月25日 下午 08:13
  • Hi,

    To grep the exact error please change the agent profile please include the -OutputVerboseLevel 3 and output path where ever you like to catch the output log, we can easily diagnose the issue.


    Regards JakDBA Please Mark this as Answered if this solves your issue or satisfied with the response.

    2012年4月27日 下午 03:25