I have 2 servers with 2 kinds of replications between them.
One is Transactional and the other is merge.
The Transactional replication is working fine but in the merge replication, I’m getting error messages.
The merge process could not connect to the Publisher ‘ ‘. Check to
ensure that the server is running. (Source: MSSQL_REPL, Error number:
MSSQL_REPL-2147198719) Get help: http://help/MSSQL_REPL-2147198719 The
process could not connect to Publisher ‘ ‘. (Source: MSSQL_REPL, Error
number: MSSQL_REPL20084) Get help: http://help/MSSQL_REPL20084 Login
failed. The login is from an untrusted domain and cannot be used with
Windows authentication. (Source: MSSQLServer, Error number: 18452) Get
Two weeks ago everything was working fine (we didn’t change anything and they didn’t change as well).
I’ve read and check that the user is db_owner.
Telnet is open (and the transactional replication is working) so there are not any network problems.
I deleted and recreated both replications.
when I’m looking at the publisher server events log I see the error
SSPI handshake failed with error code 0x80090301, 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.