Does the Windows Failover Cluster for a multi-subnet SQL Server Availability Group require a static IP entry for each subnet?
The instructions I am finding for a Failover Cluster Instance (FCI) in a multi-subnet environment require separate IPs but I am not creating any FCIs - only an availability group.
I am running SQL Server 2012 on Windows Server 2012 Hyper V VMs in 2 separate subnets in the same domain. I understand that I will need an IP from each subnet when I create the listener for my AAG. What I am unclear on is the configuration of IPs on the underlying Windows Failover Cluster.
Can I get away with using a single IP in the same subnet as the primary replica or do I need to add an IP from the secondary replica's subnet as well?
Also, if the server hosting the secondary replica does require its own IP, does it also require its own unique cluster name as stated in this blog post (and can you explain why this is necessary)?: