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
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
Additional Information
If the DTC problem is not solved, perform a more thorough diagnosis using the steps described in the following Microsoft Knowledge Base Articles:
- Troubleshoot MS DTC Firewall Issues, which you can find at http://support.microsoft.com/default.aspx?scid=kb;EN-US;306843
- Troubleshooting Linked Server Error 7391, which you can find at http://support.microsoft.com/default.aspx?scid=kb;EN-US;306212
- Use DTCTester Tool, which you can find at http://support.microsoft.com/default.aspx?scid=kb;EN-US;293799