Create SQL Server Availability Group (AG) cluster on Azure
This is a complete video on how to create SQL Server Availability Group cluster on Azure.
Chapters:
0:00 - Introduction
0:13 - Configure accounts in Domain
9:26 - Add accounts to replicas
16:19 - Install Windows Failover Clustering Features
17:40 - Set Firewall Rules
19:33 - Install Windows Failover clustering (WSFC)
22:30 - Add nodes to the cluster
23:52 - Enable AG cluster features
25:58 - Create AG database
26:30 - Create backup share location
28:50 - Create AG cluster in SSMS
The command used in the video while giving permission to NT AUTHORITY:
=================
USE [master]
GO
CREATE LOGIN [NT AUTHORITY\SYSTEM] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
GRANT ALTER ANY AVAILABILITY GROUP TO [NT AUTHORITY\SYSTEM]
GO
GRANT CONNECT SQL TO [NT AUTHORITY\SYSTEM]
GO
GRANT VIEW SERVER STATE TO [NT AUTHORITY\SYSTEM]
GO
🚀►The prerequisite video on creating a domain:
• Quickly create a domain on Azure Virtual m...
📚 ►SQL Server internals: • SQL Internals
📷 ►Follow me on Instagram - https://www.instagram.com/arslanov_bo...
🧑💼►Follow me on LinkedIn - / bobirmirzo-arslanov-548960173
Watch all my playlists here:
🚀►Full course on Encrypting connections to SQL Server- • Full course on Encrypting connections to S...
🚀 ►SQL Server replication session: • SQL Server replication
🚀 ►SQL Server Always On Availability Group: • SQL Server Always On Availability Groups (AG)
🚀 ► Full course on Troubleshooting sessions: • Troubleshooting
🚀 ► Course in On-memory OLTP: • Course on In-Memory OLTP