How to Configure MS SQL Failover Cluster in MS SQL Server 2019 - Step by Step

Video Statistics and Information

Video
Captions Word Cloud
Reddit Comments
Captions
as you know i'm kinds on the tech pro and in this short video i'm going to show you how to set up a sql failover sql server fill over cluster using sql server 2019 step by step so i've actually written all these types to follow here in my website so this is the steps i'm gonna follow right now and this is my setup so this is basically the setup i have right here uh in this image we have node one it's gonna be one of the cluster nodes node 2 the second cluster node so we are talking about two node cluster and then we are going to use uh this is going to be the storage node now how to set up a windows uh cluster is already in the description box because before you can set up sql server closer you must already have a windows cluster so here is my node one so the easy node one running on windows server 2019 is free free edition you can see it's running for 580 days and this is my note 2 you can see all of them in the same network and this is my active directory you can see all the nodes right here i also have a windows class a zero one a fill of a cluster for windows not sql philippa cluster technology these are two different things we are going to be talking about uh this later on if you have any challenges following these please leave me a comment below so the first thing we want to do now i know the steps so but for you you might have to open this and leave it open so the first thing you want to do is to install fill over closer in node one and then add node two to the cluster all right so i'm going to go to sql server setup i'm going to run the site up and to install sql server fill over closer you are going to use the sql server setup so go to installation right here and choose new sql server fill over cluster installation right here i'd like to remind you to subscribe to my channel if you've not subscribed subscribed please click on the subscribe button below so that you don't miss any update and also if you have any challenges whatsoever please leave me a comment now let's go to the next step uh simply go next i don't need no updates and it's going to run some of this set up that tests and let's see so you can see that it tells us a class a service very verification warning i think you can ignore that let me check i really don't know um so we have so i think we can ignore this for now and we can proceed next next and accept the license and click on next so we need database engine and they select every other thing so go next so installation of clause is basically uh straightforward but i think it comes to a place i'm gonna have to explain to you when it comes to cluster network configuration and this configuration and stuff like that so this for now is the basics we are doing so let's call it sql cluster 0 1 sql cluster 0 1 and go next so there are validation errors so it says uh the giving classroom is unusable because there was failure trying to determine if the network closer uh so basically i know where this problem is coming from and is actually coming from um if you are using virtualbox so you have this problem so the solution to this problem is simply to to uninstall visual box guest addition i'm gonna do it right now and i'm going to continue in this process so i'm going to visual box guest addition to add remove programs so at this point i have removed um i've removed the visual box guest additions and at this time i'm going to give the cluster a name so you can give the same name as a network name so this is what i use right here and you'll see that the problem will not be there so at this point you can see that we we've come to this place so if you go to the step by step you can see that um they that failure that failure we are seeing right now sorry let's take all this so this is where we are so this is what we are seeing right now in this installation so this types are very very very clear to follow so simply go next so we have a cluster disk tool uh this one cannot be used because it is is a quaran drive uh you can actually add more disks to cluster later on i'm gonna show you so i'm gonna go next now you have dhcp assigned ip address version four so select because my dhcp uh is my domain controller as well so but if you are not using a dhcp you can actually assign manually ip address right here so i'm going to go next and see the easy account i want to use and i'm going to say okay and i'm going to use the same uh for the database engine as well so i'm gonna i'm gonna also paste it right here and so this it can be manual it can be automatic okay we can't change it and we go next all right so i think everything is okay so they are validation errors please close the dialog box okay i think i need to enter enter the password here as well all right so it works and we need to decide what kind of authentication i'm going to use i'm going to be using windows authentication and i'm going to use the same so have data directories i think i should leave all of these as default so everything here can be default and i'm going to simply go next so in the next tutorial i'm going to be going deep deeper into different aspects of of sql server installation for now this is the basics and let's allow it to install and then we are now going to go to server 2 and add this installation to and add node two to this cluster all right so you can see that our cluster installation succeeded on node one so we once you create an sql fill overclock sign one nodes you don't need to create the same cluster in the second node you simply go to the second node and add that node to the cluster so at this point if you go to if i go to my domain controller and i simply refresh i could see the sql cluster created so let's try to refresh i'm going to refresh so you can see sql plus zero one created right here with two nodes so if i now go to node two so this is my node two and at this point i'm going to simply add the the cluster uh this node or the this computer to the cluster so i'm going to run okay i can have it from the network so you need to pay attention to this part because now once the setup starts you need to choose uh installation and then you are going to choose add node to closer so here you need to go to installation and choose add node to sql fill over closer so choose here and click on run and let's see right so go next all right so we have uh the we can see that everything passed zero failed that is fine and i'm going next next and i accept the terms i'm going next as well so we have the only class that we have here is sql sql cluster zero one and the node is node and we only have it right here so i'm going next as well now we have this cluster here although in my network i also have all the clusters but it's going to detect the cluster that has uh the same node in the same windows cluster so node 1 and node 2 they're in the same windows cluster and sql fill over cluster is installed in one node so here i say specify the ip address i'm gonna kind of yeah perfect so i'm going next so adding nodes to closer is quite uh more straightforward than installing a fillover cluster so in this case i'm gonna enter the password here right so i'm going to simply click on install to start the installation i hope it's going to take lesser time and then i'm going to show you how to view the cluster and be able to manage the cluster all right so we've added these nodes to the failover cluster and now i'm going to show you how you can check the cluster so what you are going to do is to go to start and look at server manager now you can check the closer uh you can manage the cluster from any of the nodes now have node one and two so go to tools and you can see fellow backlos manager right here now i like to close this tool so here you can see fellow backlogger manager now you can see this wing cluster zero one this wing cluster zero one is not the sql server fill of a cluster but if you drop down and you go to roles you should be able to see that this wins when classes zero one a windows fill of a cluster contains um sql server fill over closer as you can see right here now if we go back to node one and i also go to the same panel from here so if you go to tools and go to failover cluster manager you will also be able to see the closer so one thing we can do is to be able to add additional disks or additional nodes to the cluster so that i'm giving you as an assignment try to figure out how to add additional nodes to the cluster so so here you can see the cluster right here and um yeah so if you go to nodes you can see the two nodes and the the main thing is that this close sign is running so once this is running it means that if one node goes down you you'll be sure that your database is running in the other node i'm going to be stopping here so there's a basics please try to be able to install this on seti top by yourself and we are going to be uh continuing in the next part please remember to subscribe and also leave me a comment if you have any challenges whatsoever
Info
Channel: Kindson The Tech Pro
Views: 56,108
Rating: undefined out of 5
Keywords: Failover Cluster, High Availability, SQL Server, Microsoft SQL Server 2019, Step by Step, From the Scratch
Id: S9B6185Mx_c
Channel Id: undefined
Length: 12min 5sec (725 seconds)
Published: Mon Oct 26 2020
Related Videos
Note
Please note that this website is currently a work in progress! Lots of interesting data and statistics to come.