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

  Рет қаралды 64,944

Kindson The Tech Pro

Kindson The Tech Pro

Күн бұрын

Пікірлер: 28
@barrettdittburner8990
@barrettdittburner8990 2 жыл бұрын
Do you install SQL server on a Node that also has Windows clustering? Or are the SQL nodes seperate nodes from windows clustering nodes?
@AmarullaKhan-j2u
@AmarullaKhan-j2u Жыл бұрын
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.
@bongsuiruverla4373
@bongsuiruverla4373 Жыл бұрын
Thanks for this video king
@KindsonTheTechPro
@KindsonTheTechPro 2 ай бұрын
You're welcome 😊
@ibrahimdiarra3104
@ibrahimdiarra3104 4 жыл бұрын
I need your help with a web service project using database
@roshanjohn3076
@roshanjohn3076 2 жыл бұрын
Hello Sir. How on node 2 the installation wizard detects the instance SQLCLUSTER01?
@matthawrysko
@matthawrysko Жыл бұрын
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?
@DeckDestroyerZ
@DeckDestroyerZ 3 жыл бұрын
Does this also Distribute loads? Currently dealing with a overloaded database (1600 Req's per second, 800 Sessions average).
@vauvau1823
@vauvau1823 4 жыл бұрын
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
@krishnarai3123
@krishnarai3123 5 ай бұрын
Thanks for sharing this videos
@KindsonTheTechPro
@KindsonTheTechPro 4 ай бұрын
My pleasure 😄
@manmohan7750
@manmohan7750 10 ай бұрын
Hello pls share full configuration setup video
@qqq2001pk
@qqq2001pk 2 жыл бұрын
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
@sunilkanumarla3857
@sunilkanumarla3857 3 жыл бұрын
Hi I am using os windows 11 home Is it possible to do on person pc
@zakhan4291
@zakhan4291 2 жыл бұрын
I need help to create AG is work with raplication
@krissoysa1094
@krissoysa1094 2 жыл бұрын
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
@firefoxx46
@firefoxx46 5 ай бұрын
Thank you very much.
@KindsonTheTechPro
@KindsonTheTechPro 4 ай бұрын
Welcome 😊
@doctordey6473
@doctordey6473 2 жыл бұрын
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
@panthuya4849
@panthuya4849 Жыл бұрын
Thanks you are a saver!
@anatiti19
@anatiti19 3 жыл бұрын
Why do I need a domain controller? What happens if decided to go without it ? I need answers for both please.
@KindsonTheTechPro
@KindsonTheTechPro 3 жыл бұрын
We are creating a domain network. You can also use a workgroup, but domain network is what you'll likely encounter in real work environment, so it's better you get familiar with it.
@pranaydeshmukh2473
@pranaydeshmukh2473 Жыл бұрын
Hello can u pls help us on sql clustering
@9813374818
@9813374818 3 жыл бұрын
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.
@MS-717
@MS-717 3 жыл бұрын
good job
@qqq2001pk
@qqq2001pk 2 жыл бұрын
Network name has to registered with DNS
@channel-dp6je
@channel-dp6je 2 жыл бұрын
Can we create database cluster with various databases(MS SQL with MY SQL)? Is it possible?
@qqq2001pk
@qqq2001pk 2 жыл бұрын
No but you can use poly base service to add mysql
How to Configure Failover Cluster in Windows Server 2019 - Step by Step
16:49
Kindson The Tech Pro
Рет қаралды 114 М.
Арыстанның айқасы, Тәуіржанның шайқасы!
25:51
QosLike / ҚосЛайк / Косылайық
Рет қаралды 678 М.
How to treat Acne💉
00:31
ISSEI / いっせい
Рет қаралды 18 МЛН
Introduction to SQL Server Failover Clustering
36:33
Brent Ozar Unlimited
Рет қаралды 91 М.
How to Create SQL 2019 Always ON High Availability
1:06:39
Skill Set with Shehzad
Рет қаралды 45 М.
35. How to Create a Failover Cluster in Windows Server 2019
20:03
MSFT WebCast
Рет қаралды 80 М.