Forum Discussion

Paul_Remblance's avatar
Paul_Remblance
Copper Contributor
Jun 18, 2022

SQL 2014 Merge Replication

I have hit a brick wall with this one.

 

On my home network we have two laptops (Win10Pro) and a desktop acting as publisher. We all use the laptops to update a membership system (SQL2014).

As far as I can see both laptops are set up the same, the only difference being the computer names set up in the merge subscriptions. Just on one of them the subscription gets created on the publisher but wont initialise. Publisher SQL Log:

 

06/18/2022 09:11:07,Logon,Unknown,Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: 192.168.1.115]
06/18/2022 09:11:07,Logon,Unknown,Error: 18452<c/> Severity: 14<c/> State: 1.
06/18/2022 09:11:07,Logon,Unknown,SSPI handshake failed with error code 0x8009030c<c/> state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. The logon attempt failed [CLIENT: 192.168.1.115]
06/18/2022 09:11:07,Logon,Unknown,Error: 17806<c/> Severity: 20<c/> State: 14.

 

It all works fine on the other laptop. All PCs are logged in with the same Microsoft account.

 

Any help at all would be welcome.
 

  • Paul_Remblance's avatar
    Paul_Remblance
    Copper Contributor
    Please ignore, found the repl_merge password was entered incorrectly!

Resources