Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Location
    USA
    Posts
    115

    Unanswered: Merge Replication Error - Help Required...

    Dear Friends,
    I am very new to replication, For learning purpose I am trying to setup merge replication. The given setup I am using.

    1. Windows 2000 Server + SP4 (Publisher for SQL 2000)
    2. Windows 2003 Server + SP1 (Subscriber For SQL 2000)

    I am getting a replication error, I have taken this errors details from merge agent on publisher server.

    Find enclosed replication error details in the microsoft document file format (.doc). The document is consist of three SQL Server snapshot rather three diffrent errors.

    In the pictures you can find the red & white color cross (wrong sign) on replication monitor tab, I don't know why it is appearing.

    Kindly, give me guidance to rectify this error & setup the marge replication between two SQL 2000 Servers.
    Attached Files Attached Files

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    It appears to be a folder or file permissions issue:

    Full (Error) Message : The process could not read file '\\RENMAIL\C$\Program Files\Microsoft SQL Server\MSSQL\ReplData\unc\RENMAIL_pubs_pubs\200604 18105537\publishers_1.sch' due to OS error 5.
    OS error 5 is "Access is Denied" (net helpmsg 5).

    You need to check the permissions on the folder to which the snapshot is published and verify that the SQL Server Service account for the publisher has read/write access to this folder.

    Regards,

    hmscott
    Have you hugged your backup today?

  3. #3
    Join Date
    Jan 2006
    Location
    USA
    Posts
    115
    Yeah, you're right hmscott that appropriate rights assignment is essential.

    But there is other properties also to configured... At the last I have configured "Microsoft SQL Server Replication Remote Dist Agent 8.0" DCOM property on the operating system. The command line to configure DCOM is 'dcomcnfg'.

    Now merge replication is working good... Thanx...

Posting Permissions

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