Tuesday 25 September 2018

SQL Server: Install the cluster management WMI objects on Non-clustered servers


There may be need to have cluster management WMI objects on standalone server like in my case , script needs these objects in order to collect clustered server details.

If server is not a cluster node, it doesn’t have cluster management WMI objects installed. In this case, we need to manually install the WMI objects. 

This is the procedure to install the clustering WMI objects:


On Windows 2012 Hosts:

- open a Powershell command or Powershell_ise and run the following command to install the clustering Automation Server only
  (msclus.dll only, does NOT install clustering support; just this management tool):

        install-windowsfeature RSAT-Clustering-AutomationServer

- additionally for managing via Powershell scripting, you may also want to install:

        install-windowsfeature RSAT-Clustering-PowerShell



Hope it will help