Hi Edwin, just a remark to this great presentation, at +- 20 minutes you're bringing online the harddisks and initialized them as MBR. For drives not required to boot from it is adviced to initialize as GPT as these drives can serve volumes larger than 2TB. MBR cannot go beyond that limitation.
Agreed. I've been waiting since Windows Server 2008 for someone to finally notice. You're the only one 😊 Remember the good-old days of Windows Server 2003 SP1?
@@EdwinMSarmiento Dear Sir, thanks for the reply. I am trying to implement a SQL Always On high availability with 3 nodes where two is in one premises and another one is in remote premesis, which are connected over Ipsec tunnel. The problem is, in cluster configuration, in the validation it says the remote one is not connected or turned on whereas its connected and can be ping through Name or ip, moreover all neccsessary ports for cluster are opened in both routers and nodes but still cant connect. Can you please help me out?
Can SQL cluster work on a workgroup environment instead of an Active Directory environment? Thank you. Btw, cannot find the link to download the checklist, thank you.
> Can SQL cluster work on a workgroup environment instead of an Active Directory environment? If you're referring to a SQL Server failover clustered instances, it's not supported. Only SQL Server Always On Availability Groups work with workgroup clusters as of SQL Server 2022. Here's a video on how to install and configure a Windows Server Failover Cluster without Active Directory ruclips.net/video/jDvqP1372Lo/видео.html
This one www.udemy.com/course/sqlserverhadrdeepdive However, just because you can follow a video tutorial doesn't mean you'll be able to implement it properly. Building a SQL Server failover clustered instance requires properly configuring every layer in the stack - servers, VMs (if you're running virtual machines), storage, networking, Active Directory, DNS, failover clustering, and SQL Server. One misconfiguration is all it takes to cause an extended outage.
Wolfpac with Sphinx, for those who still remember the codenames 🙂 The principles and concepts remain the same...despite all the hype of whatever is new in the industry
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
Dear Edwin, we truly appreciate the effort you have put into creating this material. It's certainly very helpful.
Thanks for taking the time to go through each step! Extremely helpful for me! I'm going through a two-node cluster setup.
Very informative , thanks for your effort to make this video's
Hi Edwin, just a remark to this great presentation, at +- 20 minutes you're bringing online the harddisks and initialized them as MBR. For drives not required to boot from it is adviced to initialize as GPT as these drives can serve volumes larger than 2TB. MBR cannot go beyond that limitation.
Agreed.
I've been waiting since Windows Server 2008 for someone to finally notice. You're the only one 😊
Remember the good-old days of Windows Server 2003 SP1?
Found this from a post from Erik Darling. A bit late yet great discovery
hi. you mentioned providing a link to the cluster preparation checklist spreadsheet?
The link should be on the description
learnsqlserverhadr.com/clusterprepchecklist
where are the four storage drive came from? Is it shared or its from the internal HDD?
SQL Server failover clustered instances require shared storage. A SAN that supports SCSI-3 persistent reservation can be used as shared storage.
@@EdwinMSarmiento Dear Sir, thanks for the reply. I am trying to implement a SQL Always On high availability with 3 nodes where two is in one premises and another one is in remote premesis, which are connected over Ipsec tunnel. The problem is, in cluster configuration, in the validation it says the remote one is not connected or turned on whereas its connected and can be ping through Name or ip, moreover all neccsessary ports for cluster are opened in both routers and nodes but still cant connect. Can you please help me out?
@@ahmedreja3717 This requires a more intensive troubleshooting to figure out the root cause and not something a response can solve.
Can SQL cluster work on a workgroup environment instead of an Active Directory environment? Thank you. Btw, cannot find the link to download the checklist, thank you.
> Can SQL cluster work on a workgroup environment instead of an Active Directory environment?
If you're referring to a SQL Server failover clustered instances, it's not supported. Only SQL Server Always On Availability Groups work with workgroup clusters as of SQL Server 2022.
Here's a video on how to install and configure a Windows Server Failover Cluster without Active Directory
ruclips.net/video/jDvqP1372Lo/видео.html
@@EdwinMSarmiento Thank you very much for the reply.
which udemy course included this training pls?
This one
www.udemy.com/course/sqlserverhadrdeepdive
However, just because you can follow a video tutorial doesn't mean you'll be able to implement it properly.
Building a SQL Server failover clustered instance requires properly configuring every layer in the stack - servers, VMs (if you're running virtual machines), storage, networking, Active Directory, DNS, failover clustering, and SQL Server.
One misconfiguration is all it takes to cause an extended outage.
Did this in 1999 Advanced Server 2000 and SQL7 clustering, BLAST from the PAST
Wolfpac with Sphinx, for those who still remember the codenames 🙂
The principles and concepts remain the same...despite all the hype of whatever is new in the industry