Issue monitoring clustered SQL Server - WMI Cannot Connect

kmonroe@psecu.com

Can someone help me out with this. I'm trying to monitor a cluster. Everything connects just fine with the exception of the actual cluster itself. We receive the following error in the SQL Monitor log.

GetInstances: Root\MSCluster select State,Name,Description,Type,__RELPATH from MSCluster_Resource

Any help would be greatly appreciated.

Thanks,
Kevin

chriskelly

Please can you run the WMI test which is detailed in this document. It utilised the wbemtest utility which is provided by Microsoft.

http://documentation.red-gate.com/x/1wCi

However, at step 3 please can you specify the namespace "\\myserver.example.com\root\MSCluster" and at step 6 use the query "select State,Name,Description,Type,__RELPATH from MSCluster_Resource". These are taken from your error message and will ensure that the test results are relevant.

ptrubs

The link above from @chriskelly us broken...

Victoria W

@ptrubs

That's an old post, here's the link you need:

https://documentation.red-gate.com/sm/adding-and-managing-monitored-servers/preparing-for-adding-monitored-servers/what-to-try-if-you-hit-connection-problems