Environment
NetIQ AppManager 8.0
Microsoft Windows 2003
Microsoft Windows 2008
Microsoft Distributed Transaction Coordinator
Situation
Resolution
In SQL Management Studio, run the following query against the NQCCDB Database:
Begin distributed Tran
Select * from [hostname].[QDB].dbo.object
Commit Tran
Replace [hostname] with the name of the SQL Server hosting the repository in question, and replace [QDB] with the actual repository name (which is QDB by default).
If you get rows returned, you do not have an MSDTC problem. If you get an error, you likely have an MSDTC issue, the error in the query results should provide more information to troubleshoot with. NetIQ is not responsible for MSDTC issues, you should work with a Server Admin or Microsoft to resolve this issue.