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 AUTHORITYSYSTEM] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
GRANT ALTER ANY AVAILABILITY GROUP TO [NT AUTHORITYSYSTEM]
GO
GRANT CONNECT SQL TO [NT AUTHORITYSYSTEM]
GO
GRANT VIEW SERVER STATE TO [NT AUTHORITYSYSTEM]
GO
The prerequisite video on creating a domain:
[ad_2]
source
-
-
-
-
