Also, using a sysadmin DB server role for the cluster name, and 2 nodes login, with SQL sa as the "local" credentials.
Usually at least 3 or 4 times a week, sometimes twice a day, at unpredictable times, SQL Monitor will send an Alert:
- Code: Select all
SQL Server: (local)
Machine: <<The Cluster>>
Alert type: Monitoring error (SQL Server data collection)
Time raised: 1 Feb 2013 8:01 PM (UTC-05)
Time ended: 1 Feb 2013 8:04 PM (UTC-05)
I need to send you a file of the base monitor log as this has been going on for many months without resolution.
The hosting company's Windows experts have changed what I believe is the packet authentication to public as we had seen a number of security messages and rebooted each node.
I ran the WMI Test and have 160 Win32_Service objects.
As I said, the issue is INTERMITTENT. I caught the log file this time. I'd like to upload it so your experts can see what's up as I'd like to have a reliable monitor, please...