Make sure the xp_cmdshell is enabled. Most of the cluster information is obtained by running the cluster command via xp_cmdshell.
Also make sure you have followed the steps below in order to monitor a SQL Server cluster effectively:
1.Create a Windows connection for each physical node in the cluster
2.Create a SQL Server connection that uses the virtual name and set the Linked OS connection to ‘Cluster (monitor active node)’ <- THIS IS VERY IMPORTANT SINCE IT IS DIFFERENT THAN IN PREVIOUS ONES)
Then Spotlight will select the Windows connection that monitors the active cluster node when the SQL Server connection first connects. During a fail–over the SQL Server connection is disconnected and re-connected so the active Windows connection selection occurs again at that point.
For customers who upgrade they should remove any Windows connections that use Windows cluster virtual host names, ensure they have Windows connections for the physical nodes in the cluster, and then change the Linked OS connection to ‘Cluster (monitor active node)’.
