3

I am using Idera SQL Diagnostic Manager to monitor a Windows Server Failover Cluster with two SQL Server 2008 R2 clusters configured to run with one SQL Server cluster on each node. It just started reporting that one of the instances does not have DTC or SQL Server Agent installed.

I've RDP'd 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 Server 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 Server 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 SQL Diagnostic Manager has me perplexed since it is new (the error).

Running:

EXEC master..xp_servicecontrol N'QUERYSTATE', 'MSDTC'

on both nodes results in "Running".

1 Answer 1

3

Typically, 0x80070005 is an Access Denied error. Perhaps the account Idera SQL Diagnostic Manager is using no longer has access to the Service Control Manager on the Windows nodes where the errors are occurring.

4
  • 2
    i'll upvote you for the effort and the answer. unfortunately this was 4 years ago and i no longer work at this company so i can't validate your assumptions. also, my opinions on DM are ... not very favorable.
    – swasheck
    Mar 24, 2016 at 16:55
  • 2
    thanks - I guess you never know, this may help some poor fellow in the future.
    – Hannah Vernon
    Mar 24, 2016 at 16:56
  • I am the poor fellow from future...it is a permission issue but still unresolved to me
    – Zac
    Oct 11, 2021 at 13:15
  • @Zac - If you have a new or similar question and can provide further details, please ask it by clicking the Ask Question button. Include a link to this question if it helps provide context.
    – Hannah Vernon
    Oct 13, 2021 at 17:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.