Issue:
When
we tried to update table data, which uses triggers with linked servers
It
will through error.
Solution:
To
resolve this we should need to configure DTC(Distributed Transaction Coordinator)
Settings like below in both Source and Destination
RUN------------>
dcomcnfg.exe
Expand
"Component Services"
Expand
"computers" >
Expand
"My computer"
Expand
"DTC"
Right
click on the server and make the same config as below step for the "local
DTC"
Place
a check in the Network DTC Access
and the Allow Inbound and Allow Outbound
under the Transaction Manager Communication option. We also selected No Authentication Required, as this was the way the other servers
in the environment were configured.
Restart
the DTC services from Services.msc
We
should need to same config on source and destination
Issue
fixed now
We
can update data using linked server inside triggers as see below
No comments:
Post a Comment