Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have an Active/Active Sql 2008 R2 cluster that I monitor with Idera Sql Diagnostic Manager. It just started reporting that one of the instances does not have DTC or Sql Server Agent installed.

I've RDP to the cluster, and both nodes. In the cluster manager I see the DTC node running and is owned by the "A" node. On the "A" node, there are two services called "Distributed Transaction Coordinator." On the "B" node (which is the node on which the instance throwing the error on Sql Diagnostic Manager) there is only one service (in services.msc) called "Distributed Transaction Coordinator." There is an error in the event log that says

Failed trying to get the state of the cluster node: SERVER-DTC.The error code returned: 0x80070005

This cluster node is on the "A" node along with a Sql instance. The "B" node has this error. I can list and enumerate jobs in SSMS in the instance that is on the "B" node, but the Sql Agent does not have the little green triangle in it (just the empty circle).

So, I don't know exactly what to do. It seems like things are working OK, but this message from Idera SDM has me perplexed since it is new (the error).

EXEC master..xp_servicecontrol N'QUERYSTATE', 'MSDTC' on both nodes results in "Running"

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.