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.
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
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.
