Setup and Configure Windows Server 2016 Failover Cluster Without Active Directory
Vložit
- čas přidán 16. 10. 2018
- Previous versions of Windows Server Failover Cluster required tight integration with Active Directory. This makes it challenging for SQL Server DBAs who need to deploy failover clustered instances (FCI) or Availability Groups.
Windows Server 2016 introduced the ability to implement a failover cluster without any dependencies in Active Directory. The member servers can be a part of a workgroup or even different Active Directory domains and forests.
In this video, we will build a 3-node Windows Server 2016 failover cluster without Active Directory.
This video is a part of an in-depth online course: Windows Server Failover Clustering (WSFC) for the Smart SQL Server DBA.
For more information, visit www.LearnSQLServerHADR.com
If you want to watch more videos about SQL Server high availability and disaster recovery, do yourself (and me) a favor and subscribe to my CZcams channel right here:
bit.ly/29rOqLy
And if you want to get even MORE great free content (just like this), make sure you sign up on my mailing list.
That's where I share exclusive tips that I never reveal publicly or on CZcams:
Sign up here: LearnSQLServerHADR.com - Věda a technologie
One of the clearest tutorials I've seen on this topic.
In case someone will be doing the same but without DNS server - add Node names with their IPs to hosts file (both nodes). In ethernet adapter settings add your gateway as primary DNS server. Also add DNS suffix in changing Computer Name section.
This is the hammer in the right nail. I really appreciate your inside on this subject. I hate the idea of joining Hyper-V host to a Domain. I have been looking for a solution to this.
I know I will loose some Hyper-V functionality like VM Replicas and Live Migration. But that's is an acceptable lost to me because I haven't had the need for either so far after 10 years using hyper-v.
Brilliant, Thanks for video
Glad you liked it!
Hi Edwin.. could also explain as to how u configured the storage
Configuring the storage depends on your storage subsystem. You should ask your storage vendor on how to properly configure your storage for Windows Server Failover Clustering. Every storage vendor has a different way of configuring storage.
hi and thanks for this tutorial,
can you please explain how to install sql server in cluster mode without active directory account, i do what you explain in this video step by step, but after that, when i try to install sql server in "New Sql Server failover cluster installation" mode, in one of the installation part it say that you must enter an active directory account for SQL server AGENT.
You cannot install a SQL Server failover cluster in a Windows Server Failover Cluster without Active Directory. This is intended for SQL Server Always On Availability Groups
@@EdwinMSarmiento thank you edwin.
Is there any security caveat using WSFC without Domain Controller?
You need to understand why organizations implement Active Directory in the first place. They want a centralized directory service to allow connecting users with network services. Security is just one aspect of Active Directory.
So, when companies decide they don't want to use Active Directory, they must have a valid reason for doing so.
Hi Edwin,
I have two Windows servers in Azure. They are not part of the domain. Two standalone nodes which i am planning to install SQL server and setup a Always On availability group.
I am following your video to setup failover cluster, however, i do not have a separate DNS server in my setup. Is there a way around it? Can i install DNS role on my Node01 and then configure failover cluster?
You can just put the entries in the hosts file (C:\Windows\system32\drivers\etc\hosts). Just put the ip address & the hostname in there & save it. Do this on all your nodes & put all the ip's - hostnames in there of all servers for your cluster
@@dzengiztafa510 You can also explicitly create DNS records for the servers themselves on your DNS server. This is recommended over creating entries in the hosts file.
i see is a pretty old video, but i have a question.... why use dns and not edit a hosts file ? i wll have less dependency ... you depend from DNS in this way.... is still the same with 2022 ?
> why use dns and not edit a hosts file
Scalability.
When you have more than 2 nodes to manage, you have to think of how you can do more with less.
Hi I just created the cluster with 2 nodes. 2 nodes already install the apps (the apps without built-in HA version) under generic application failover. My question is after I done the create the failover cluster and how client link to the apps and use the apps prevent downtime? hope you can assist thank you : )
You need to create a Client Access Point for your clustered role and use that for client application connectivity
@@EdwinMSarmiento UO already done. now I stuck at here how to execute the application via the cmd or powershell : (
Talk to the apps developers, ask how they configure application connectivity.
i know active directory .But what is active directory with high availabilty (HA) and disater recovery
(DR)
What do you mean by "what is active directory with high availability and disaster recovery?"
@@EdwinMSarmiento is it possible to create redundancy for active directory?
@@jonnelboozpabalan6110 Yes, it is. You just need to have at least 2 domain controllers for redundancy
social.technet.microsoft.com/wiki/contents/articles/24457.how-domain-controllers-are-located-in-windows.aspx