How to Create SQL 2019 Always ON High Availability 

Required to setup a SCCM Always available group DB. Watched this and completed in no time. Great.

Very nice۔۔۔informative ۔❤❤❤

Short-Simple and awesome... Keep it up!!!

That was an epic tutorial. Imagine i tried it using Windows Server 2022 and SQLServer 2022 and was successful.

Excellent MR Muhammad, thank you

Great teacher my mentor. ❤

Fantastic video! Thank you

appreciate bro, very well. but here you are using donain admin account , in production is it good practice

Excellent Video !

Please upload some videos about replication and log shipping and how interview questions will be ask on these topics

Excellent effort Br. Muhammad for the step by step details to configure High Availability feature on SQL2019. There is some audio disturbance that started towards the end.

جزاك الله خير

Excellent Muhammad !! Thanks alot

So nice sir this is really helpful

Hey man, nice basic video. Please in the future; Take care of security as well. You are granting computer objects full control on OU.

sUPER!

Thanks very informative...one question, Is the listener HA ?

Like. Thanks

Hey Muhammad, nice video! Quick question, why does the database on the secondary replica stay in restoring mode? I noticed that happened in your example and the same thing happened to me as well

Inglés I am very grateful for the video, but despite doing absolutely and to the millimeter everything you do in the video, there is something wrong with me, let me explain. I create the availability group with the wizard and when I get to the end, it does it for you, but it doesn't do the Join 'test1' to availability gorup 'SQLGA' on 'Node2' check, but it does it for me and it stays like this, waiting and waiting... (I indicate that the ports are enabled and that from the management studio, I see from both nodes, to the other node. Also, since the wizard does not end, in the replicas tab, node 1 is with the replication symbol and node 2 is with a red X. Any help?

So these are some ways of HA in sql [Failover Cluster, Availability Groups, transactional replication] am I right?

Please do video about what is features will be add 2000 to 2019 versions

why do you need to grant connect SQL explicitly to domain account where it is already sys admin ?

Thanks for the help. Can the shared folder be removed after the availability group is set up or must it remain to continue the syncing functionality?

upload some work on managed instance with Microsoft Azure please

in the video Active Dir what's the purpose of the folder that you put the SQl servers in...

is Doman must for Always on ? or can Always on be configured without domain ?

The shared folder that is created. What exactly is that used for? Can it be created on any of the SQL nodes? But is that node goes down, what would be the impact?

When adding replica, I am getting "Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement."

Just to Clarify I am pointing My SQL Clients to the ag-listener and not the WSQLCL Windows Cluster Name or IP? Or can I do both?

which ip we have added in connection string on web. conf file

While trying to configure always on, cluster type drop down showing only two options 1.External 2.None. The windows failover cluster is not showing in the list. Why it is coming like , can u help to solve the issue.

Thanks my brother, but is this Active/passive or not?

Brother, thanks for an explanation but I've followed all your steps but when creating AAG it shows the connection to the primary replica is not active. the command cannot be processed error 35250, do you have any solution

Is the primary sql always writing to the secondary?

Thanks for the demo and info, have a great day

you can not set an domain admin in a windows service

Very bad decision to change SQL Server service logon account from Services Control Manager, you need to do it from SQL Server Configuration Manager for SQL Server to assign required privileges for this account to work properly

How to get it working without a domain environment?