Spotlight 11.1 use the “Cluster.exe” tool to list all cluster nodes for SQL server 2005 to 2014. “Cluster.exe” is included in windows feature “Failover Cluster Command Interface”. If the cluster server do not have this feature, Spotlight can’t detect cluster nodes and “Node Unavailable” alarm will be raised.
This Windows Cluster feature needs to be enabled for Spotlight to work. See attachment KB184852_Fig01.png.
Once the Windows Cluster is enabled, please disable and enable monitoring of the SQL server cluster connection on the Spotlight side.