The information in this article applies to product: e-Work 6.x
Issue
- "MS DTC is unable to communicate with MS DTC on a remote system. No common RPC protocol is supported between the two systems. Please ensure that one or more of the following RPC protocols are common to both systems: TCP/IP, SPX, or NetBEUI.”
- Failed to process 'eExecuteSQL' e-Work Database Connector request. ErrorCode: '-2147217900'. Description: '\[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator.\]'. Source: 'Microsoft OLE DB Provider for SQL Server'. SQL State: '01000'. NativeErrorCode: '7312' ErrorCode: '-2147217900'. Description: 'The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.'. Source: 'Microsoft OLE DB Provider for SQL Server'. SQL State: '42000'. NativeErrorCode: '7391' Procedure SelectSQL call failed. Position: 95
Resolution
- Verify that Network DTC access is enabled on the Windows Server 2003 machine. See this link http://support.microsoft.com/default.aspx?scid=kb;en-us;817064 for more information.
Restart the DTC services on both engine and database machines.
- If there are still errors after Network DTC access is enabled, try the following (this option is not available if SP1 has been applied):
Go to Administrative Tools > Component Services
- right-click the appropriate computer node and select 'Properties'
- on the 'MSDTC' tab, click 'Security Configuration'
- in addition to 'Network DTC Access' being checked, check 'Network Transactions'
- Restart the DTC services on the two machines and test.