SOLVED

SQL 2014 Merge Replication

New Contributor

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.
 

1 Reply
best response confirmed by Paul_Remblance (New Contributor)
Solution
Please ignore, found the repl_merge password was entered incorrectly!