How does Remote Deploy Configuration wizard determines the physical node names before adding them? Is it by broadcasting across the network or maybe it relies on the virtual SQL Server instance -> Cluster name to determine the nodes?
Steps:
1) The wizard connects (WMI) to the cluster name and reads the value below to identify “is it a cluster” Cluster name (if empty –> non clustered configuration)
SOFTWARE\Microsoft\Microsoft SQL Server\ + Instance + \MSSQLServer\CurrentVersion\ClusterName
2) If it is clustered, the wizard retrieves (WMI) cluster nodes list using SELECT Name, Type, PrivateProperties FROM MSCluster_Resource
Gets resource names where Type == "SQL Server" for each name exec query
SELECT GroupComponent, PartComponent FROM MSCluster_ResourceToPossibleOwner WHERE GroupComponent = "MSCluster_Resource.Name = ResourceName";
PartComponent is a node name
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center