General solution that MS SQL Server OLE DB distributed transactions cannot start

Source: Internet
Author: User
Tags sql ole
server|sqlserver| Distributed | solution
This article belongs to Spanzhang original, its blog address is: Http://blog.csdn.net/spanzhang. Quote or paste, please specify the source, thank you!!

Server: Message 7391, Level 16, State 1, line 6
The operation could not be performed because the OLE DB provider ' SQLOLEDB ' could not start the split
Cloth-type transactions.
[OLE/DB provider returned message: cannot be in the specified transaction processor
Get a new transaction. ]
---------------------------------------------------------------------------------------------
Server: Message 8520, Level 20, State 1, line 8
Commit of internal MSDTC transaction failed: Result Code = 0x8004d019.

Connection interrupted
---------------------------------------------------------------------------------------------

This problem, I want to do MS SQL Server distributed database system people have encountered. The simple time is the service did not start, 135 ports did not open and so on. But when you're done with all this stuff, you're going to be desperate and wondering if Ms simply can't use OLE DB to start a distributed transaction. In fact, many times a problem in the presence of the time will make you feel mysterious, but the solution is actually very simple. Here's the answer:

1, run Regedt32, browse to HKEY_LOCAL_MACHINE OFTWARE\MICROSOFT\MSDTC.
Add a DWORD value turnoffrpcsecurity, the value data is 1.
2, restart MS DTC service.
3, open the Administrative Tools, "Component Services."
A. Browse to the Start administration tool.    B. Select Component Services.    C. Expand the Component Services tree, and then expand My Computer.     D. Right-click My Computer and choose Properties. In the MSDTC tab, make sure the following options are selected:
Network DTC access network Management network transaction XA transaction
In addition, the DTC login account must be set to "NT AUTHORITY\NetworkService". 4, restart MS DTC service.
5, run Regedt32 again, browse to HKEY_LOCAL_MACHINE OFTWARE\MICROSOFT\MSDTC, and then delete turnoffrpcsecurity items.


Microsoft provided the original: http://support.microsoft.com/default.aspx?scid=kb;zh-cn;329332


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.