Error When Using SQL Server on Windows Server 2003

Metastorm · November 5, 2004

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

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.