NEWData replication is down!

supriyo91

supriyo91

Member
6
0
1
we have one primary and 4 secondary. Currently database replication is down all 4 sites.
The following error message is visible in the all secondary rcmcrt.log:
Error: Exception message: [SQL Server Network Interfaces: The target principal name is incorrect.~~~~OLE DB provider "SQLNCLI11" for linked server "domain.com" returned message "Cannot generate SSPI context".~~OLE DB provider "SQLNCLI11" for linked server "domain.com" returned message "Invalid connection string attribute".]
Replication link analyzer shows generic message: Connection failure detected between PRI and SEC sql server
KyleASimpz

KyleASimpz

Well-Known Member
50
0
6
we have one primary and 4 secondary. Currently database replication is down all 4 sites.
The following error message is visible in the all secondary rcmcrt.log:
Error: Exception message: [SQL Server Network Interfaces: The target principal name is incorrect.~~~~OLE DB provider "SQLNCLI11" for linked server "domain.com" returned message "Cannot generate SSPI context".~~OLE DB provider "SQLNCLI11" for linked server "domain.com" returned message "Invalid connection string attribute".]
Replication link analyzer shows generic message: Connection failure detected between PRI and SEC sql server
Were you able to resolve this issue?
We have 1 primary and 5 secondary and all the secondary sites have replication issues.