DTC fails to communicate in Windows 2003. (NETIQKB50359)

  • 7750359
  • 02-Feb-2007
  • 23-Jul-2010

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x
NetIQ Control Center 6.x
NetIQ Control Center 7.0.x
Microsoft Windows 2003, Enterprise Edition

 

Situation

DTC fails to communicate in Windows 2003.
Error: 'Executed as user: NETIQUS\name. The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. [SQLSTATE 42000] (Error 7391)'

Resolution

By default, the network access of Microsoft DTC is disabled on new installations of SQL Server 2000 on Windows Server 2003. 

To enable network access, follow the steps in the Microsoft Knowledge Base article, You Receive Error 7391 When You Run a Distributed Transaction Against a Linked Server, which you can find at http://support.microsoft.com/default.aspx?scid=kb;EN-US;329332.

In some cases, you must start the DTC service before you start the computer that is running SQL Server so that the linked server distributed queries work well.

If you still experience the problem, follow the steps in the Microsoft Knowledge Base article, Fails to Mutually Authenticate When Computers Do Not Run in the Same Domain, which you can find at http://support.microsoft.com/default.aspx?scid=kb;EN-US;827805.

Cause

Microsoft DTC is having a problem communicating over a network. The DTC may not be network access enabled. If it is network access enabled, you may be experiencing a Microsoft issue where the DTC proxy in Windows 2003 may not correctly authenticate MSDTC when both computers are not in the same domain.

Additional Information

Formerly known as NETIQKB50359

If the DTC problem is not solved, perform a more thorough diagnosis using the steps described in the following Microsoft Knowledge Base Articles: