#StackBounty: #sql-server-2008 #replication The merge process could not connect to the Publisher ' '. Check to ensure that the …

Bounty: 50

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.

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
help: http://help/18452

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.

Any ideas?

Get this bounty!!!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.