I have a SQL Server 2008 R2 instance on a two node (say names X and Y) Windows server cluster (Windows Server 2008 R2 Enterprise).
Server Manager on both nodes shows 'X' as the 'Current Host Server'.
However, when I run
ServerProperty('ComputerNamePhysicalNetBIOS') it returns
'Y' which should be the current active node.
If I RDP to the SQL's IP, it indeed connects to Y.
- Which one is the correct one?
- Why does Server Manager shows X as the active node?
ServerProperty('MachineName') returns neither
'Z'. Z is the name of neither computers. What does it represent?
According to BOL for ComputerNamePhysicalNetBIOS (which returns Y as above):
If the instance of SQL Server is in a failover cluster and you want to obtain the name of the failover clustered instance, use the MachineName property.
Then, why does it return Z?
These machines are not virtualized, they are physical. Does it mean Z is the virtual server name of the cluster? "current host server" seems to refer to the "Active Node in the cluster" (from an online forum). I am not entirely sure what is meant by that with two FCIs and one active on each node.