Databases
StackOverflow2013
Postsdbo
POSQL Server Merge - Pull replication error
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQL Server Merge - Pull replication error
    primarykey
    data
    text
    <p>I have a configuration problem to create a Merge/Pull replication between two databases SQLServer 2012.</p> <p>The machine Publisher is a Windows Server 2008 R2 not in windows domain, this Server is also the Distributor. The machine Subscriber is a Windows 8 not in windows domain.</p> <p>I have made the following settings: in the Published Server i created the distributor's folder, "repldata" and I also shared it and suser "everyone full control". The path's folder is \servername\repldata</p> <p>see image: www.alessandrosenesi.com/download/distributor.jpg</p> <p>I created Publisher, see image: www.alessandrosenesi.com/download/Publisher.jpg</p> <p>I created Subscriber see image: www.alessandrosenesi.com/download/subscriber.jpg</p> <p>I have done some settings in Distributor, Publisher and Subscriber but I don't get results, I always have access error.</p> <p>see image: www.alessandrosenesi.com/download/log.jpg</p> <hr> <pre><code>Error messages: The schema script 'BOOKING_2.sch' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001) The process could not read file '\\nomemacchina\repldata\unc\nomemacchina$MSSQLSER VER2012_nomereplica\20130930125944\BOOKING_2.sch' due to OS error 5. (Source: MSSQL_REPL, Error number: MSSQL_REPL0) Access Denied. (Source: MSSQL_REPL, Error number: MSSQL_REPL5) </code></pre> <hr> <p>Can you tell me where is the problem? I have to do this replication but it looks like to be not possible</p> <p>Thanks in advance Alessandro </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBrandon Williams
    1. USAlessandro S
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSQL Server Merge - Pull replication error
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COYou need to use a Windows account that has the same username and password on both Publisher and Subscriber and use this account when you create your Subscription "Run under the following Windows account" and have the Connection to the Publisher and Distributor impersonate this account.
      singulars
      1. POSQL Server Merge - Pull replication error
      1. USBrandon Williams
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload