How to Install & Configure SQL Server 2016 Failover Cluster Step By Step

- so go to my channel and today in this video I am going to show you let's go Server 2016 failover clustering solution and configuration is same by step so I am going to use a Windows Server 2016 the whole news 2016 server to give you this demo so let's have some idea about my Dame environment before moving this this are discussing about the demo environment I want to discuss what is failover hosting so basically failover cluster we have a feature on Windows which is called Windows failover cursor which provide a high availability for the roles or the things services which is running on the cluster so if any node goes down we can resume the services from from one node to another node like if if I am running ESCO server on my node 1 and due to some power outage of maintenance or any and anything which need to be done on node 1 we can the services which is running on node 1 like SQL we can migrate the school's server from node 1 to node 2 and we can do the maintenance on any activity on node 1 one is come back we can add the add the node again in a production to provide the high availability for the SQL Server or any services which is running on clusters so so the basic requirement we need a shared storage along with all the nodes which is participating in Windows failover coaster so we will discuss everything in next few few minutes so here is my environment I am using basically one active reactors over into SQL node here so if you go back so the first ever is Vinh 2 K 16 DC 0 1 which is my aqueduct a domain controller here you can see the active active server and my domain name is with 10 for soul comm if you go here on here if it click on local server you can see when twin 2k 16 DC 0 1 and this is this is basically running my activity and DNS road so this is my active active server and if you go next I have two SQL server cluster node here you can see yes called cluster so the first node is phase node one and second one is SQL node two and SQL node one so both are joining my domain if let's check so this is node 1 and this is no - so if I go to local server you can see the SQL node SQL - node 1 and if you go here SQL node - - and both are join in my domain and my domain like victim for soul comm and you can see the firewall state if I have at this disable the firewall for my domain on domain network so you can see off and I have done this by using the group policy in production environment if you if you are not going to disable the firewall for domain Network then I recommend to bus you need to like check the firewall ports which is using MySQL is allowed on your cluster node or not so if not then go go and create a firewall rule to allow the SQL traffic or SQL services so and you can see I have basically 304 neck physical NIC is connected with my both SQL node you can see node 1 and node 2 so basically if we buy a physical server so I want to give you the real-time environment in area so if you're going to buy a new server like like Dell are four zero two six three six one zero or seven one zero so they are coming with like four NIC mostly mostly servers are coming with a four neck so what we can do why I am using for we we can go ahead and creator or team and then we can distribute the team along with the as per our requirement for different different Network like domain network and storage network and we can define the hard we live migration everything so we will do this in next few steps so this is about this is basically a face server where I have installed a Windows Server 2016 standard edition and you can also verify the RAM and desk space which I have assigned the 60 GB disk space only so so nothing is installed for now on this server no role no feature so just machine is configured I have blank this was installed with 2016 I have configured the IP address or name the machine and joins this machine in domain that's all these three tasks I have done on both the school nodes so so let's do this step by step so you can see step by step installation and configurations of SQL Server 2016 cluster so in first step you can see install hyper-v fade of the coastal multipathing dotnet famous features on both the question also so why we are installing hyper-v here because I want to create in second step you go you can see create an ADD rotini and create a converged network and configure like so so I am solving the hyper-v because I want to create a converse network phone on both the server so converse network what we can do we can we can use all three next together and we can share the different if together for like a different different traffic for all that like fly migration heartbeat and cluster network domain network Nuys KC so I will give you the demo about this also and next step so for now I am going to add feature manager add Rowland features and click Next and here the use over click Next and now what I want to do select the hyper-v role and add features required features will be added this wait for few seconds here so we are getting this error so why we are getting this error because intel VT technology is not enable on this machine so this is the one trick we need to enable the hyper if we want to install the hyper-v we need to enable the Intel VT technology virtualization technology on your machine so if you are using a physical machine then you can go and go in by the setting and you can enable the and tell VT technology and if you are using a virtual machine like like from VMware Workstation I just you need to go and shut down machine and go and change the processor from takecare virtualize until we do technology enabled so I am going to do this so you can see along with me what we can do for here so go to shut down this machine and now go to edit virtual machine setting and go to processor and until VT technology and click OK and now power on the machine and we'll try to install the hyper-v role another feature as well as so let's wait for a few minutes to get the server up and running so ctrl alt Adele to login and here I want to show you one thing I am using a domain account which is SQL admin tool or into both my cluster node and if I you go to server actual data servers users and computers here you can see I have set created a school that minute if you go to properties in account you can see password never expires collect here because I never want to like change or if you want you can go ahead and change but I don't want to expire this password anyhow because my I'm going to run this SQL Server cluster services by using this account only and also I have created added this this account to a domain admin suta group if you don't want to add then go go ahead and add this at the service at this SQL admin account in your computer management local computer account local computer administrator so you are able to install and run or do any changes which is required on server whether you will not be able to install anything not be able to change anything so now if I go to manage add Dolan features click Next Next and select your know to click Next and select hyper-v and add features now you can see we are good to go click Next and next we need to install a failover custom multipathing and dotnet framework so select the dotnet framework 3.5 which is required for this whole server and failover clustering you know to select and go little bit down you have multipath in select next and click Next all setting for the hyper we need to be leave default and click click and specify the alternate source because because I want to install the.net framework which required alternate source for sews file so I am going to settings we am sitting and I am going to mount the installation media of Server 2016 and will give the path so is so so 2016 open so here we have open it and go to so source SSX you can see a dotnet 3.5 3 is there so here is the path click OK now click on install so this installation will take few minutes and also we need to reboot the server a few times because we are in enabling the hyper-v role so wait for the solution gets finished and same role and features I am going to install on oDesk will Note 2 so login to SQL node 2 and I am going to log in with the same account which is SQL admin wait for server manager so make sure you have enabled the intel VT technology if you having a hardware server from bios so click Next and select the hyper-v click add features everything looks good click Next dotnet framework and we need to install a failover go swing add features for failure become string and the multipathing click Next and leave the default setting for hyper-v and go to confirmation place specify the alternate source so let's map the Windows Server 2016 installation media on note 2 as well as and copy the SSX but and here you can see I have checked the restart the - initiation automatically is require so yes it's quite a reboot because we are installing the hyper role hyper-v role so let's install click on install so now it's running the installation for all the required role and features and you can see on node one the installation is completed a restart changings pending for a school node zero one so go ahead and restart the server that's why I have checked take care like automatic restart because this require a reboot to enable the hyper-v tool so now you can see it's working on features so now you can see SQL note 2 is also rebooting so both server has been rebooted and once the we are able to login we and we will go ahead and do the second step which is create neck timing and create converse Network and configure the IP address for for all for neck so we have a network network IP address plan for our cluster so you can see honest on both server I am using like for node 1 I am using 2 0 1 and last series and for no 2 2 0 2 so the domain network which is basically going to communicate with my domain is 1 9 2 1 6 8.1 series and the ICOC is 10 or 10 or 10 series and close to network is 1 9 2 1 6 8 2.10 1 or 2 0 1 and lime adjacent to 0-2 and i am going to use a Class C default subnet mask for all my 4 Network which is 2 5 5 255.255.0.0 one is up go ahead click control to del to login so wait for the server manager so you can see hyper-v role is now enabled and now we need to go to local server and here you can see the NIC teaming is disabled so go and click on it and now if you go and create a new teen and it's asking for names network team name so so you can see I have created one is or to create a converse Network and if I go to script you can see I have set the converse v-neck as a NIC teaming name to recognize as in my script so I am going to assume use the same conversion I've been ik and so at the all for neck and go ahead click OK I can see it's can disconnected and it will take some time to bring the or the team up and all the for next up so you can see one NIC is active now so to run this script I'm going to use a PowerShell is go ahead and go to more and run as administrator yes I want to run so open and go to desktop and we have a script here so before executing we can see here and creating for next with the name of domain - - v-neck is Casey - v-neck and closer and lie migration so I can see the Nick is the team is up all for Nick is up and if I go here on details you can see we have four physical Nick and one virtual neck which is basically 18 so I want to go and run this script to create a for watch hyper converse Network for us so now you can see this running script and it's adding what you will make and virtual resources so it will take not take long time it will take mostly 30 seconds to give the all know all for neck up and running so we need to wait for right now you can see it's started creating the necks and we have three neck here and four neck so all nickels created and you can see the partial script is completed and we have converged network name and we have a source like external and Microsoft Network duplex adapter so go ahead and close this and now we need to assign the IP address as per our given suite IP destination for cluster so I'm going to sign it for domain ipv6 I don't want to use so disable it one hundred two hundred one default subnet mask for Class C and I want to configure only DNS address on my domain domain network because any other traffic which is such as live migration trusted bit or ICC is not going to connect with my domain network so no need to configure the DNS address on those snakes so he attend of to end of 10.20 one two five five two five five two five 5.0 and for cluster we have a clustered network 2.2 201 so go for that one nine two one six eight so whenever you are planning to for the cluster Network make sure you have had this everything which needs to be addressed before making goes to network so I recommend you to create a hybrid hyper converse network environment as well as I will use in the cluster so one nine two six 201 and Class C close this everything is done IP config is done now go and refresh this so you are able to see here the things switches so you can see the containing is now enable and we have configured the correct IP doesn't hold for any and now same I want to go here and configure on note 2 so let's verify everything is solon hyper-v is correctly installed or not so login to snow - and wait for several managers so you can see in Solingen succeed on note 2 so go ahead and close this and verify which service is not running so start the service which is not running so now you can see the hyper-v is enable so let's create team first go here and create team and open script this is a very small script you can see and right from my video as well as if you want to write this script and also I will post this script in my details so you can get the get phone details if you want oops we have not selected one neck so anyways go ahead and select once again so wait for all the neck to bring online go to details close this and waiting connection pending so it will take some time maybe so now you can see everything is up and active so go ahead close this and now it's time to run the script so then as initiator yes I want to run and browse the script saved at my desktop location open and then you can go ahead and run this script writing a script fluxions domaine network is added ice KC coastal network and finally live migration so everything is good go ahead and close the script and now configured IP address disable IP we say + 2 + 6 8 1 dot 202 and specify the DNS address on domain network only and I scuzzy 1000 1000 10.2 hundred 2 to 5 5 to 5 5 to 5 5.0 push the network go to properties disable ipv6 go to properties and one nine two one six eight 2.1 day 2 and this is going to be 3.2 1 to 2 into 1 6 8 3 202 go ahead and close this and the first the local server so now you can see the IP address is configured on both the node correctly now we can go ahead on to next step which is go to backslide create a highly available storage on a star wind were chosen so I recommend as this is a demo so I am using this Darwin virtual sense so might be in your unit production environment it can be a fiber channel stories coming from FC stories coming from like I scuzzy devices and or any other devices HP or anything so make sure your like storage is coming from higher level H storage so in my case I am using the star window management console and I have created one target and going to add two discs here one for M discs and let's create like quorum disk for cluster 1gb I'm going to put in C Drive the starWind folder and click Next and leave the all setting default so this is basically a job which need to be done by storage admin in your infrastructure so as we are doing in this demo so I'm going to sigh one just want to show you this step also so this zero one asked us it is zero one and make it like fifty one GB and put it in C Drive starving folder click Next make the everything default now you can see we have created two disk to learn lens zero and one one and go ahead and close this and now the next step is enable I'm am pio and they start the both service so let's enable the NPI vampyre enabled basically of multipathing access the same storage device or same learn by using a same time by using more or two or more than two servers so my discover multipathing I want to as ad add support for eyes to see and if we have such devices you can go ahead enable so I made using is KC so I want to as a software add a software for iOS devices so a reboot is required to complete the operation reboot now yes I want to reboot now and say am I want to go here and do what my SQL node - so let's let's reboot this also so now about the server is booting and next step we need to discover the IOC target and add this one both cluster so we'll do the state once the machine is power like we have good to login so we converted L log into server and now go to Disk Management to see what we have currently connected with this server so we have two disks like zero one is my hard disk and we have one CD drive here which is assigned as Z drive so let's go here and tools and launch the ice crush initiator so we have a pop-up here ice case is not running the services purchased are a scuzzy to function correctly so start yes I want this service to run every time so here we have a target so my target server at B this is my physical machine which is ten dot dan Dotson click on it now you can see it's coming from the star window server 0 1 so created with and if you disconnect and reconnect it it will give you option to enable multipathing yes I want to enable multipathing click OK and now if you go here you can see that both the disk is available in my question would 0 1 so let's bring the boot disk online first and now go and in slice the disk and select the cpt or MBR whatever so I'm going to select that default one which is MBR click ok and now let's create a simple volume here and put it as a cue for qrm desk am des perform a caucus format secret disc is enabled here and go to and make it like D Drive and I see is Casey - disc cero one next and format the - so I'm is a sign this is formatting the desk currently so now you can see this drive is also enabled here so we have a D Drive and Q Drive with us and say I am going to map in my note - so long login to ask well - or to open the disk management and launch that iSCSI initiator to map the drive yes I want to run as you see and connect to the target then the 10.10.5.3 act yes star wind is there click connect and now disconnect and enable the multipathing do we connect enable multipathing click ok and now you can see the boot disk is connected so bring the board disc online you can see it's taken the D Drive but drive later automatically which is next free available so I'm going to make it like Q Drive and same I want to go here now you can see so in a both node we have a is kc disk is available as a d drive and q drive so we are done with this system a next step is like create a windows fade over coaster and modify the coaster desk and not for sitting so i am going to create now cluster on from you can run this from any of the cluster node like node 1 or no - so I'm going to run this from my node 1 so tools fail because the managers so here so we have a validation cluster validation and create crystal is not so so if you want to validate let's validate the settings first so might be you get the idea what is if anything wrong with the cluster nodes so at the node which is SQL and we have a school node 1 no 2 so I always recommend you to run the validation configuration wizard before promoting or before creating any failover Kalista so next and run all type test is recommended so go with it click Next now we have a list of fears so click knife and now you're thrilled under all that request check which is required for here so if you get any warning then it's fine you can go ahead and create the cluster but if if you have any error or any fail then you you need to go back and check your settings check your not really errors and do the required needful with your cursor notes and run the validation again if everything goes well then then go and create the question so wait for it it will take some time it will take a long time like 5 to 10 minutes to validate the number of cluster it's depend on your like Costas post speed network is speed network bandwidth and everything so wait for it and number of the disk which is a test it will both cluster nodes as also so wait for it it's checking validate multi thing and value days is qc3 position so everything is looks good here so validate this failover is test pass so so if you go and also see everything is looks good for now so we have some warning here like Matt validate Microsoft and py a base disk so I know I have to enable the NPI asserting and my both node is like accessing the both disk as at the same time so it's good to know and we can go ahead and now it's you can see it's taking disk offline online too to validate the disk is properly configured as as that can be used as a cluster disk so everything is green for now so wait for a few more minutes to get the validation complete then we can go ahead and check the report which is generated by this wizard and if everything seems good then we can go ahead and create the coastal so now you can see the validation is complete you can go ahead and view the reports as well as so let's verify the report once so if you go here you can see everything is seems fine we have few warden with related to network and stores if you go and you can see the in a network segment also we have everything successful so we have a few warning that can be ignored for now and if you see some we have some generic warning which need to be considered on not so let's create the cluster now using the validated nodes and click on finish so it will launch the create close to visit so click Next and now we need to check the like we are using one nine two one six or one nine two one six eight dot one dot zero for cluster Network so put it like one thirty one and give the name so I'm going to use this like when cluster zero one and hit next so a doll is eligible stories - plus - click Next now you can see it's creating the cluster for us so it will take some time so creating computer object when goes to 0 1 on domain controller so if you go here on a servers you can see my both notice here on the same on a scene or oh you it will create a cluster object whether your cluster node is residing so creating resource type so it will take some time bring the resource online so now it's configuring the column disk for us and you have successfully completed the create crust azad click on finish and now you can see it will load the clusters for us waiting for snap in so now you can see the we have when - plus a 0 1 dot with 10 for soul comm is running here and if we go on rolls we don't have any rolls for now we will select schools over on also node you can see we have 2 node which is a school server 1 SQL - node 1 node 2 so both node is a pen if you want to see the details you can see here like status and every operating system detail at for connection detail we have here rows if any roles is running we have a desk information both the desk is saying - no - I think so cool and physical disk also same you can go ahead and verify here and we have both the disks as I said both the disk is assigned to node 1 and node 2 so ROS nothing network connection summary we have all the details and if you go on disk we have a to disk here so let us rename this so I am going to mark at the chrome desk this is going to be hi scuzzy - so I associate this to zero one apply and you can see it's a sign - in available storage we have this is as available store and go to networks and we need to rename this network as well as so I'm going to use the same name which I have assigned here and my as to my network next so for the domain network so make it like don't know didn't change any setting just copy and paste the name so domain Winnick and second is why you can see second is I scuzzy so copy the IC name and go here copy paste and here we have a cluster network which is configured as - so and last one is live migration so let's name the final one which is live migration also we have to make sure the live migration traffic will go from this snake only so for that we have to do airline migration settings and go here and pull the line migration first at uncheck the all the necks and click apply and ok so we have done with this step and next step is like install SQL Server 2016 failover coaster on node 1 so I am going to install on node 1 first let's go server so minimize it let's close this and mount the 2016 SQL Server 2016 installation media so a school server and we have a school Server 2016 Service Pack 1 foolish it's brain frame 2x 64-bit so open it can see can go and open the program and run the setup yes I want to run as blue Server 2016 setup so this is the final step we are where we are going to install a SQL Server 2016 on a cluster so we have we have just set up a fade over clusters on Windows Server 2016 which is going to headlock hold school server failover so we have two option here add node to SQL Server fade away cursor or newest course of a fade of the cluster installation so I am going to use this on my node one new exclusive or failover coastal installations so you can minimize this so I am going to use this in a variation mode if you have lets you can install up your product key so this is the demo so I am going to use a evaluation mode click Next now we have a license term I accept the license term and click Next and we have a few checklist here so everything a pass and I don't want to use the Microsoft Update for now and if you want you can go ahead and check for Microsoft Windows of the RS crucifer date so click Next and now it's copying the installation file to local into local drive so this step might be takes few minutes it's running clearquest check so everything is past like we have a cluster node status is past if you click here roll cluster is past the local computer is a node and a Windows failover cluster so we have got to go and we have a few other checklist here which is a seems everything is passed we have a few ordinary related to dot that security application security firewall so we know we have done the basic requirement for Windows failover as we have a like a Windows Firewall as we have disabled so we are going to go and click Next and now what we want to install so I want to install the database engine services basically and also if you want to install anything you can go ahead and select the things which you want to install so I don't want to install anything a part of database engine it will like you can see it's by default it selected the schools application and data quality services and full text so good to go click Next now we have the instance name here so I want to use it to fault instance which are not used to default instance so I want to make it SQL plus 0 1 and same I want to put here so instant name is same an SQL network name is same so click Next so specified name does not meet the instance naming rules so so basically it will not accept - so I am going to use as SQL cluster 0 1 as a default as instance name and network name is basically SQL - cost is 0 and we can use it's going to use a computer it basically failover crystal object in as the computer they counter in our domain so for now you can see we don't have any cluster object related to SQL cluster so it will create this one so click Next and wait for so we go to go and cluster resource group so this is that can take some few seconds so we have here like s course of a cluster resource group name so we are going to use the same SQL server and we have available storage and processor group both so get next and now it will give you the option to configure the disk so we have one desk available as which we can use so any cluster you can see here we have the voltage that's why it's windier and escrow services are so second one is square um this so we can't use it so I'm good to go and select the desk click next and we have IP address configuration so I want to use ipv4 and don't want to use the DHCP so go here and configure the IP address 1.23 to which i want to use and you can see here my network card is already selected which is the ethernet domain neck so everything's looks good here so click Next now we have a server configuration so I want to run all the services by using my domain account with info so slash SQL admin copied and put the password for this account also so also you need to check here you can check the change it to automatic because it's running on a cluster so everything looks good here click Next and now we have a specify the authentication method so I want to use a Windows and I have added my SQL admin as administrator SQL a server admin and if you go to data by 2 you can see path is assigned to D Drive which is coming from basically which is coming from clustered risk which is here you can see I see so good to know and temporary DB is also going to create in D Drive so you can see the path for Tom perdy database so everything looks good here click Next make sure you verify the data basic drive is going to on cluster node desk and now we are good to go and here you can see the setting which we have just lectured in the this all step-by-step wizard so they're good to go and click on install and if you want to like make a note of these things you can make a note and just click on install to begin the installation so SQL installation is now take it will take around 9 to 15 to 20 minutes to get the installation done so let's see how much time it will take so well it didn't feature settings so now you can see the installation is started so I am pausing the recording here once the installation is done it will not require any manual interaction for now and once the ones that everything is installation is done for that school server we will come back and we will check the next step which is verify SQL server cluster role on the fail of the custom just created or not so I am pausing the recording for now so now you can see the installation is completed everything succeed let's close this now if you go and close this window also from SQL Server now if you go here on a roles you can see we have SQL Server is running which name is SQL instance name is SQL close to zero one and running on a node 1 and we have if you go on resource you can see the resource which is being used by this role so we have a one is cursor disks 50 GB is a disk we have SQL plus a server name which is a school - process 0-1 and IP address and the resources which services is running and the roll name so if you see here it's running on owner node is SQL - node 1 because we have installed on SQL node - 1 only and if you go on nodes and if you click here node 1 you can see the roles is running in and if is go on No - you can't see any role is running here so good to know that and now we are so we have checked everything it seems fine for now so let's do the next step which is we have verified the rest of the cluster rule 1 failover course and now the next task is as second node on SQL Server 2016 cluster basically installed let's go server 2016 on node 2 so go here and node 2 and mount installation media of 2000 exclusive 2016 so here SQL Server 2016 service pack 1 and launch the situation over clickers I want to run it wait for us desire to pop up please wait while the Microsoft rest is over 2013 setup process it will takes few seconds so here we have a click on installations and we have add in order to SQL Server failover cursor click here minimize this now select the affiliation we have installed the node on SQL Server 1 node 1 is as evaluation mode so click Next and now I accept the license terms click Next alright stunning the pre request check so everything seems good go ahead click Next and don't check for like Windows Update for now if you want to check you can go ahead and check for the Windows Update let's call server update and during the installation as well as so this step will take some time so everything is passed we have a here you can see the question mode and everything is looks good the local computer is a node in a Windows failover cluster so everything seems good for now you can see on click Next so we have an instance name where we are going to add this node so SQL node 2 is going to add in SQL Server cluster or SQL cluster 0 1 nodes so let's create next I totally check for question at the configuration if everything's goes goes fine and it will goes to next step on a CD drive you can see it's require around 1.5 gb space it will load the on network configuration settings in few seconds so you can say it's loaded the information which is running so good to go click Next and on a service account page we need to put the password for the service account which is running on node 1 so I am going to put the password here on both on both services like database service and agent the schools of agent so click Next now everything good and now we have finally click need to click on install to begin the installation of SQL Server 2016 on node 2 so everything seems good click on install so installation will take around 10 to 15 years to get this done so once the installation is done we will verify the Sekar screw server cluster role on both the nodes so for now impossible recording error once the installation is done will resume video from the F so installation is almost completed you can see it will take a lot you can say it 2 to 3 minutes to get the installation completed so well after that we will check and verify the roles has called role on Windows cluster so give it some more time to get the installation finish I can see it's removing the temporary files and everything so deleting so almost completed Oh Sofia what was the name so now you can see our school installation is succeeded and go ahead and close this and also you can go and close this installation center now if you go here on a square roll you can see a desk will roll is running on node 1 and as we have installed SQL Server failover Cassano - so we can go ahead and migrate this role on another second node which is SQL - nodes 0 - and we check it's moving or not it's working fine or not so let's do this so go to the source and you can see the everything is running on node 1 so I'm going to migrate it move to best possible node we have only one node so it will migrate there only so now you can see it's taking offline resources offline and everything is offline State so now let's bring online the desk and IP address the name is still pending it will bring online and now you can see the screw side which is still and bringing online so now you can see everything is online and node 2 only so if you verify if you want to verify it go on nodes and you can also verify them from here select the node on which the role is running and you can see from here the clustered node is running on node 2 so this is all about installing SQL Server 2016 failover culture and configuring the step by step so I want to say thank you for watching and please subscribe me for more videos and if you have any query education related to this please post me on my given mail ids thank you once again bye bye

Channel: Labs Hands On

Views: 75,272

Keywords: sql server 2016, sql server 2016 cluster installation, sql server 2016 clustering step by step, sql server 2016 configuration, sql server 2016 failover cluster, sql server 2016 high availability, sql server 2016 alwayson, sql server 2016 alwayson availability groups, sql server 2016 alwayson availability groups step by step, sql server 2016 availability groups, sql server 2016 backup, How to Install & Configure SQL Server 2016

Id: 8fRARjppq2k

Length: 57min 44sec (3464 seconds)

Published: Wed Jun 21 2017