We are monitoring 9 SQL servers but I found some of them keeps getting the following errors some days ago:
Monitoring error (SQL Server data collection)
Monitoring stopped (host machine credentials)
Yesterday afternoon when this error occured three times I checked the event log and found this exception:
15 Oct 2012 5:20 PM WMI OpenNamespace: root\\cimv2 Cannot connect COMException Call was canceled by the message filter. (Exception occured at HRESULT: 0x80010002 (RPC_E_CALL_CANCELED))
I have did the testing data collection methods which the Red Gate suggests and checked the network,AD,firewall(always closed),necessary services,etc.
Sadly,I found nothing at last.Can anybody help me with this?