Very informative. Many thanks! Just a quick note on the use of the domain admin account. This is OK for demos like this, but as an Infrastructure Administrator, noting grinds my gears more than when production systems use the domain admin account, or even worse, someone’s personal admin account, instead of a dedicated service account.
@14:00 - is that a secure thing to do? Do you remove them from security after you deploy AlwaysOn AG? Is there a better, more secure way of doing this? who is creating the computer item in AD, is it the Microsoft Cluster? or is it the SQL server?
Hi M. Shehzad Arshad, i have 2 questions for your video: 1. is this video building Active-Passive MSSQL? 2. If it is active-passive MSSQL, i just need 1 set of MSSQL core licenses + software assurance license right? Thanks.
Good afternoon, I have a problem when putting the network name of the sql server cluster, it gives me the error "the network address is invalid" and it doesn't let me proceed. I have created a DNS host (also the reverse) with an IP inside the network but it keeps failing. Do you know what is wrong? I have the virtual environment set up with 3 windows server 2022 machines, one domain and two in a cluster with two ISCSI disks. Thanks in advance.
![[#2024MAMA] ROSÉ (로제), Bruno Mars - APT. | Mnet 241122 방송](http://i.ytimg.com/vi/dgGqD28J6aQ/mqdefault.jpg)
Very informative. Many thanks!
Just a quick note on the use of the domain admin account. This is OK for demos like this, but as an Infrastructure Administrator, noting grinds my gears more than when production systems use the domain admin account, or even worse, someone’s personal admin account, instead of a dedicated service account.
Nice job
@14:00 - is that a secure thing to do?
Do you remove them from security after you deploy AlwaysOn AG?
Is there a better, more secure way of doing this?
who is creating the computer item in AD, is it the Microsoft Cluster? or is it the SQL server?
Fantastic, this helped me alot. Thank you.
Your welcome
is it possible to do an SQL Server 2019/2022 AlwaysOn AG /w Listener in a Workgroup environment?
Hi M. Shehzad Arshad,
i have 2 questions for your video:
1. is this video building Active-Passive MSSQL?
2. If it is active-passive MSSQL, i just need 1 set of MSSQL core licenses + software assurance license right?
Thanks.
How many nic cards required for windows cluster and sql cluster
Good afternoon,
I have a problem when putting the network name of the sql server cluster, it gives me the error "the network address is invalid" and it doesn't let me proceed. I have created a DNS host (also the reverse) with an IP inside the network but it keeps failing. Do you know what is wrong? I have the virtual environment set up with 3 windows server 2022 machines, one domain and two in a cluster with two ISCSI disks.
Thanks in advance.
Nice work mate...
Where is the MSDTC Service , What is the use of that service ?
Can we have. Call ?
Hi Rocker yes we can here you go with my number +92 302 5759187 ( whatsapp also same number)