Thanks for a great tutorial! What could be the reason that I cannot select Cluster type: Windows Server Failover Cluster? (It's missing from the dropdown). I have a Failover Cluster set up with two nodes all green no warnings.
@Sire4o4
2 жыл бұрын
Ok found the solution. The oldest of them all. Try switching it off and on again! Disable AlwaysOn feature in SQLServer Configuration Manager and enable it again.
@TechStory0
2 жыл бұрын
Thank you for watching, I'm happy to hear you were able to resolve this! Yeah it is an oldie but a goodie, when all else fails switch it off and on again. I even have that on a mug somewhere 😊
@qqq2001pk
2 жыл бұрын
SQL1 and SQL2 has one Static IP address for Cluster because they are on same subnet ? What if SQL1 and SQL2 on different data centres ? will we need two static IPs each ?
@qqq2001pk
2 жыл бұрын
During Create Cluster Wizard, when enter Cluster Name, if the (2 Node) network is different for each node, then wizard will ask for 2 IPs, each for one network. Please confirm.
@qqq2001pk
2 жыл бұрын
that will also raise another question, how to configure listener in this sitation?
@TechStory0
2 жыл бұрын
Thank you for watching! From what I understand you have the two nodes (two win server VMs) on different subnets. If that's the case, you can use their IP addresses during the wizard if there is no DNS solution in place to handle the name lookup. Of course for this to work you need to have proper routing in place. This can be through a routing protocol such as OSPF for example, or a simple static route, depending on your needs and the setup you have. I hope this was helpful.
Пікірлер: 8