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

This video explains how to configure MS SQL Failover Cluster in Microsoft SQL Server 2019

[vauvau]

Hello King. the videos you make are really great, and for that I say thank you again for all the efforts.
I know you don't have enough time, but please also answer their questions posted in comments, moreover you ask yourself, but you do not react.
Thank you

[barrettdittburner]

Do you install SQL server on a Node that also has Windows clustering? Or are the SQL nodes seperate nodes from windows clustering nodes?

[DeckDestroyerZ]

Does this also Distribute loads? Currently dealing with a overloaded database (1600 Req's per second, 800 Sessions average).

[lvljfsm]

Hello, what below error says? any suggestion to rectify this>

Cluster IP address resource 'Cluster IP Address' cannot be brought online because the cluster network 'Cluster Network 1' is not configured to allow client access. Please use the Failover Cluster Manager snap-in to check the configured properties of the cluster network.

Hi, we are using cluster due to unexpected restart of data centre now SQL node 1 is working fine but on node 2 SQL server service s not running.error 1067 .The process terminated unexpectedly.

[mhawrysko]

Hello, this is very good. Thank you for breaking it down. Once you build your initial cluster can you add an existing SQL server that is a different version of Windows to it and replicate?

[krissoysa]

Hi, thanks for the videos. We have a requirement to have a SQL FCI without a domain, on a workgroup. However, this runs into a block at SQL server FCI install when it keeps asking for a domain account as a service account. error is "specified service account is not valid. To continue, provide a domain account for SQL server Agent service" - thanks

[doctordey]

Doctor Dey
0 seconds ago
thanks for teaching, it is really helpful.
but unfortunately do not have any other server in my environment using as a ISCSI target server, is there any other way to do clustering without having a 3rd server involvement as Storage server ... Please Answer

[roshanjohn]

Hello Sir. How on node 2 the installation wizard detects the instance SQLCLUSTER01?

[sunilkanumarla]

Hi I am using os windows 11 home
Is it possible to do on person pc

[ibrahimdiarra]

I need your help with a web service project using database

[emciphorseben]

What will happen if the dc1 to dc2 link got disconnected? Will the cluster still work?

[zakhan]

I need help to create AG is work with raplication

[qqqpk]

Can you please also make video for windows server failover cluster without share disk and sql server HA/DR 3 nodes, 2 nodes on once data centre and 1 node on another data centre with different subnet, this video is FCI

[anatiti]

Why do I need a domain controller? What happens if decided to go without it ? I need answers for both please.

[pranaydeshmukh]

Hello can u pls help us on sql clustering

[manmohan]

Hello pls share full configuration setup video

[qqqpk]

Network name has to registered with DNS

[channel-dpje]

Can we create database cluster with various databases(MS SQL with MY SQL)? Is it possible?