Today when a local machine updates another server data directly in the trigger: MSDTC is not available
The workaround:
In Windows Control Panel--Administration Tools--service-->distributed Transaction coordinator--> Properties--Start
1.
A. Use a SELECT statement without a transaction. Can I get a distributed query?
B.linkserver cannot operate on native operations while doing distributed update transactions. (That is, you cannot loop back a distributed transaction)
C.DBCC TRACEON (3604, 7300)--use tracking to see more specific error messages.
D. Download the MS-provided DTCPing.exe on both machines and follow the readme instructions to execute it. Look at the error message.
Http://download.microsoft.com/download/complus/msdtc/1.7/nt45/en-us/DTCPing.exe
2.
Whether the MSDTC for both machines is turned on.
3.
The MSDTC settings are correct.
1). Open a command prompt, execute "net stop msdtc", and then execute "net start MSDTC".
2). Go to the Component Services administration tool.
3). Browse to start Administrative tools.
4). Select Component Services.
A. Expand the Component Services tree, and then expand My Computer.
B. Right-click My Computer and select Properties.
C. On the MSDTC tab, make sure that the following options are selected: Network DTC access network Management network transaction XA transaction
E. In addition, "DTC login account" must be set to "NT Authority/networkservice".
5). Click OK. This will prompt you to "MS DTC will stop and start again."
All dependent services will be stopped. Please press ' yes ' to ' continue '. Click "Yes" to continue.
6). Click OK to close the My Computer properties form.
4.
MSDTC relies on the RPC,RPC port is 135, test 135port whether to open. Is there a firewall? The fake has a firewall off first.
Telnet IP 135
Suppose it is turned off by opening it.
5.
Some machines for various reasons, SQLOLEDB cannot use distributed transactions and change to "MSDASQL" ODBC mode joins.
Use RRAS instead of RAS. (Control Panel-management tools-Remote services Manager)
Check Whether you is using remote access Server (RAS) to access remote servers. If so, make sure. Implemented Routing RAS (RRAS). Linked server does not work on RAS because RAS allows only one-to-one-on-one-to-one-.
6. Check that your two servers are in the same domain. If you are not in the same domain, you establish a trusted join.
7. Assume WIN2000, upgrade to SP4
8. Upgrade MDAC to more than 2.6, preferably 2.8.
9. The latest patch to install SQL: SP3a
It's easy to say. A lot of other online search