OK, no I'm getting this error on subscriber when I try to update record of table being replicated:
Server: Msg 7391, Level 16, State 1, Line 5
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
I even did :
1. Start Registry Editor (Regedt32.exe).
2. Locate the following key in the registry:
3. On the Edit menu, click Add Value, and then add the following registry value: Value name Data type Value
TurnOffRpcSecurity REG_DWORD 1
4. Quit Registry Editor.
as per microsoft KB http://support.microsoft.com/kb/827805.
still didn't work.
Please guide me.