MSDTC not available in Ms-sqlserver workaround

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.