locked
Help Setting up Merge Replication RRS feed

  • Question

  • I've been trying to setup Pull Merge replication between two computers. The Publisher/Distributor is in a workgroup running server 2008 and SQL Server 2008 R2. The subscriber is in a domain running server 2008 ans SQL server 2008 R2. both machines have a windows account with the same UserID and Password. The Snapshot folder is shared with 'everyone' with write permissions. I keep getting "The schema script 'xxxxxx.sch could not be propagated to the subscriber. '

    From what I read this is a permission error, but I thought having the folder shared to 'everyone' with write permission would fix that.

    Any Ideas?

    Sunday, March 8, 2015 7:43 PM

Answers

All replies

  • Hello,

    Run the agents under the SA account. and let us know if it resolves the issue.


    Regards, Pradyothana DP. Please Mark This As Answer if it solved your issue. Please Mark This As Helpful if it helps to solve your issue. ========================================================== http://www.dbainhouse.blogspot.in/

    Monday, March 9, 2015 3:30 AM
  • Hi Justhininabouti,

    Based on the error message, it is normally a permissions issue.  The agent can't get read or list files and folders access to the share/folder where the snapshot is. There are some proposals for you troubleshooting this issue as follows.

    1. Use this windows account which you has created as process Account for all the replication agents.
    2. Save the publication snapshot files under an UNC folder. And make sure that the default snapshot location is specified correctly. For more details about modifying the default snapshot location, please review this article: https://msdn.microsoft.com/en-us/library/ms151258.aspx?f=255&MSPPError=-2147217396
    3. Make sure that the windows account has access to the above UNC folder.

    However, if the issue persists, please help to post error messages in SQL Server ErrorLog for analysis.


    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support


    Monday, March 9, 2015 7:33 AM
  • Yes, it should, but you also need to ensure that the everyone group has rights to read and list files and folders on the physical folder underlying the share.

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

    Monday, March 9, 2015 2:17 PM
    Answerer
  • I tried to revert the Snapshot location to the 'Default' Location after making the change, the Snapshot agent would not start. When I viewed the staqtus it hung on 'Starting Agent' Decided to delete and rebuild the publication, but this process fails with the following .... 'Invalid Object Name 'dbo.sysmergepublications'' This has gone from bad to worse.
    Monday, March 9, 2015 2:24 PM
  • OK I got the publication Recreated.

    So This is what I have...

    On The Publisher/Distributor...

    The 'Default Snapshot Location' is on a UNC shared path '\\<server name>\Repldata' which is shared with everyone as co-owner

    The Snapshot Agent runs under the windows account .\<UserName>

    Connection to the publisher is 'By impersonating the process account'

    On the Subscriber...

    The Agent process account is set to .\<UserName>   * note this is the same username as Agent above.

    Distributor connection and Publisher connection is set to 'Impersonate Agent Process Account'

    Snapshot Location is set to 'Default Location'

    Still getting the same error.... From the publisher...

    Error messages:
    The schema script 'Address_2.sch' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
    Get help: http://help/MSSQL_REPL-2147201001
    The process could not read file '\\server\ReplData\unc\SERVER$CMLDBSERVER_CMLEMPLOYEEDB_EMPPUB\20150309122431\Address_2.sch' due to OS error 53. (Source: MSSQL_REPL, Error number: MSSQL_REPL0)
    Get help: http://help/MSSQL_REPL0
    The network path was not found.
     (Source: MSSQL_REPL, Error number: MSSQL_REPL53)
    Get help: http://help/MSSQL_REPL53


    Monday, March 9, 2015 9:05 PM
  • Error messages:
    The schema script 'Address_2.sch' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
    Get help: http://help/MSSQL_REPL-2147201001
    The process could not read file '\\server\ReplData\unc\SERVER$CMLDBSERVER_CMLEMPLOYEEDB_EMPPUB\20150309122431\Address_2.sch' due to OS error 53. (Source: MSSQL_REPL, Error number: MSSQL_REPL0)
    Get help: http://help/MSSQL_REPL0
    The network path was not found.
     (Source: MSSQL_REPL, Error number: MSSQL_REPL53)
    Get help: http://help/MSSQL_REPL53


    Hi Justhininabouti,

    Are you able to navigate to the shared folder from the Subscriber?

    Here is a similar thread regarding to the error for your reference.
    http://stackoverflow.com/questions/23409786/the-process-could-not-read-file-due-to-os-error-53

    Thanks,
    Lydia Zhang



    Lydia Zhang
    TechNet Community Support


    Tuesday, March 10, 2015 9:14 AM
  • As I said the Publisher is on a home group the subscriber a domain. the machines are only connected via internet. So, no I cant navigate to the folder.

    I have attempted VPN, but each machine is behind a NAT router, and have not been able to get a connection.

    Tuesday, March 10, 2015 12:20 PM
  • Hello,

    Please check the network issues particular the VPN.

    https://support.microsoft.com/kb/321822?wa=wsignin1.0 
    Thursday, March 12, 2015 8:59 AM
  • use push - this way you will not need to worry about the snapshot share, ensure that your default snapshot folder is not a share, but a local folder, ie c:\temp

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

    Friday, March 13, 2015 2:10 PM
    Answerer