Server: Message 7391, Level 16, State 1, Row 6 This operation is not performed because the OLE DB provider 'sqloledb' cannot start distributed transactions. [OLE / DB Provider Returned Message: New transactions cannot be obtained in the specified transaction processor. ] --------------------------------------------------- -------------------------------------------- Server: Message 8520, level 20, state 1, line 8 internal MSDTC transaction submission failed: Result code = 0x8004d019.
Connection interrupt ------------------------------------------------ -------------------------------------------- this problem, I think People who have done MS SQLServer distributed database systems have encountered. When it is simple, the service is not started, and the 135 port is not open. But when you still don't work after you get these things, you will feel desperate and suspect that MS can't use OLDB to start distributed transactions. In fact, many times a problem will make you feel mysterious when there is an emergence, but it is actually very simple. The following is the answer: 1. Run the regedt32, browse to HKEY_LOCAL_MACHINE / SOFTWARE / Microsoft / MSDTC. Add a DWORD value TurnoffRPCSecurity, value data is 1.2, restart the MS DTC service. 3. Open "Component Services" of Administrative Tools.
a. Browse to the "Startup Management Tool". B. Select "Component Services". C. Expand the Component Service tree and expand "My Computer". D. Right-click My Computer, then select Properties. In the MSDTC tab, make sure the following options are selected: Network DTC Access
Network management
Network transaction
XA transaction additionally, "DTC Login Account" must be set to "NT Authority / NetworkService". 4, restart the MS DTC service.
5. Run the regedt32 again, browse to HKEY_LOCAL_MACHINE / SOFTWARE / Microsoft / MSDTC, then delete the Turnover ProFRPCSecurity item.
Microsoft provided by:
Http://support.microsoft.com/default.aspx?scid=kb;zh-cn; 329332
If you have done it, but you can't, please ask your firewall administrator to open the port. If you can't still do it, check your connection server settings. In the Server Options, you will use the Remote Collation to the Use Remote Collation.
This article is originally created by Span Zhang (Zhang Youbang), please indicate the source. China's original fractal art, the first stop of China's original fractal software
