Thank you for the step-by-step instruction regarding setting the sign-on accounts about 45 seconds in. I was trying to make this work for a week, nothing on the internet that I could find worked, and you solved it for me with a minute.
@Kingbezy
2 жыл бұрын
I like how clear & brief this was. short, clean & straight to the point!!! tnks brother. i needed this refreshment.
@josevilla6503
3 жыл бұрын
only a few of comments respect this video, you need to open on firewall port 5022 and 1433 in both nodes, else it wont work the AG, also you need to set in SQL Service an acoount from domain
@KindsonTheTechPro
2 жыл бұрын
Thanks for the clarification😊
@Dafugcasimock
3 жыл бұрын
Short, clear, Straight to the point, thanks, good video
@dougrush742
8 күн бұрын
Good presentation
@KindsonTheTechPro
7 күн бұрын
Glad you think so!
@szehong9174
3 жыл бұрын
good job man ! you saved my life
@kunalkrishneel9478
2 жыл бұрын
hi, thank you, it was really helpful. can try Basic Always On availability with MS SQL Failover Cluster So in this case you wud have 3 servers,2 VMS on the failover cluster, running Basic Always On availability - passing data to 3rd VM running its own instance
@AviationIT
3 жыл бұрын
Thanks for the video. I have one doubt can theses nodes placed in 2 different data centers?
@darrylstaflund3431
Жыл бұрын
This was really helpful. Thanks.
@srinuvasuamaladasu8745
Жыл бұрын
This is so beautifully explained.
@KGBD47
2 жыл бұрын
Great quick video, but I prefer you show and resolve critical on node 2 from 7:41. Thanks
@Avis4134
Жыл бұрын
critical is only when failover under progress..
@querubindemayo3474
9 ай бұрын
Hi, thanks for this video. I have a question - What is the difference between the Always-On High Availability and Mirroring and Replication?
@andreibratosin1199
Жыл бұрын
How can I create automatic database copies between cluster nodes for incoming new databases that are transacted?
@krishnarai3123
2 жыл бұрын
Thanks for this video
@KindsonTheTechPro
2 жыл бұрын
Most welcome 😁
@manishjoshi2516
3 жыл бұрын
Thanks a lot, this helped!
@KindsonTheTechPro
3 жыл бұрын
Glad it helped! And do remember to subscribe 😃
@smibrahim84
3 жыл бұрын
The Nodes should be part of Windows Cluster for HAG setup. Is that required? How about using Listener IP as Node IP, instead of DHCP setting?
@KindsonTheTechPro
3 жыл бұрын
Yes. HA should be based of Windows Cluster. It is required. The Listener points the the cluster and not to individual nodes.
@vimalprince4467
2 жыл бұрын
how to add new DBs in an existing AG group?
@rohit-hj1xe
2 жыл бұрын
Yes we can for that Right click on Always on group which you created and just simply add another databases but as per Microsoft standards we can add max 10 db per AG.
@vimalprince4467
2 жыл бұрын
@@rohit-hj1xe thanks Rohit. I got it from other tutorial video but thanks for sharing.
@jesusmanuelsanchezmendoza6053
8 ай бұрын
¿¿¿¿Como se puede configurar lectura/escritura en ambos servidores??
@dpicollege
2 жыл бұрын
ok i running ha but my app connection string is on my primary sql server so what's ha do for me?
@rohit-hj1xe
2 жыл бұрын
When your primary db or replica gose down it will automatically changed connection strings.
@synetalsolutionsprivatelim8849
Жыл бұрын
How you get dhcp option while configuring the Listners?
@meghanatoraskar5301
2 жыл бұрын
Good video
@KindsonTheTechPro
2 жыл бұрын
Thanks a lot 😊
@surekhaanupoju4730
2 жыл бұрын
Thanks sir
@KindsonTheTechPro
2 жыл бұрын
My pleasure 😊
@Avis4134
Жыл бұрын
are u working as DBA?
@prabhu0408
2 жыл бұрын
Hi, Nice video demonstration, could you please let me know if i can install SQL 2019 Std for Always-On High Availibility ?
@jawids3226
3 жыл бұрын
very good video
@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.
@Real_SacredSpace
3 жыл бұрын
Thanks for the video. Should the nodes be attached to a domain controller.?
@BkBalu
3 жыл бұрын
Do we need quorum disk for AAG
@rohit-hj1xe
2 жыл бұрын
Yes
@enriquejosemunozavellan5517
3 жыл бұрын
Hey how can i have two different servers on one computer?
@josevilla6503
3 жыл бұрын
you can use vmware workstation or hyper-v on windows 10
@fathuthreev2279
2 жыл бұрын
Pointless video. At the start already shows they connected? It magically gets connected?
@KindsonTheTechPro
2 жыл бұрын
The focus here is 'Always-On'. I made other videos and tutorials on Sever Admin, SQL Cluster setup etc. See the link provided in the video description.
Пікірлер: 44