How to Configure Availability Group in SQL Server 2016 - SQL Server 2016 DBA Tutorial

Scenario:

How to Configure Availability Group in SQL Server 2016?

Solution :

The video demo will walk you through all the steps required to create / configure AlwaysOn availability Group in SQL Server 2016. Below items are covered.

• What are requirements and best practices of configuring Availability group in SQL Server 2016?
• How to prepare Windows node to be added as part of AG 2016 Cluster
• How to Create Windows Cluster step by step 
• What are the best practices of creating Availability Group Windows Cluster
• How to Configure Availability Group Role in SQL Server 2016
• How to resolve error like 
• User/Cluster doesn’t have permission to create computer object in Active Directory or DNS
• Node 1 cannot communicate with Node2 
• Joining Database takes forever and throw permission error
• Missing End Point in Availability Group properties

Part 1:

Part 2:

Part 3: