Always On

Basic Definition and terms:

https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server?view=sql-server-ver16

i created Setup on my laptop using VMware,

We Need below software 

1) VMWare Setup

2) Windows Server OS (2016/209/2022)

3) SQL SERVER 2019/2022

4) SSMS

VMware Setup

https://customerconnect.vmware.com/en/downloads/details?downloadGroup=WKST-PLAYER-1750&productId=1377&rPId=111473

2)     Install windows server 2019.

https://www.microsoft.com/en-us/evalcenter/download-windows-server-2019

3)     Create 4 machines on VM,

4)     1.DC01 -------Domain Controller (active directory)

2.SQLNode1

3.SQLNode2

4.SQLNode3

DC01 – Install Active Directory on this machine

Domain Name – swaraj.com

Create Domain user on DC01 – swaraj\sagars

Add member of -Domain User and  Administrator group

Date Time Setting –Change to IND location- Depends on your location.

Change IP address, IP address should be below: DC01 - 10.1.1.21

On main machine (SQLNode1) –

Create share folder –

for SQL Server setup and SSMS tool – Download SQL Server and SSMS Tool

Copy paste to SQLNode2 & SQLNode3

SQLNode1 - 10.1.1.22

SQLNode2 - 10.1.1.23

SQLNode3 - 10.1.1.24

Disable Firewall on SQLNode1/2/3

Rename sever name as SQLNode1/2/3 add them into swaraj Domain.

Restart Server.

Install SQL Server & SSMS on SQLNode1/2/3– while installing sql server use domain user.

SQL SERVER service and SERVER Agent service should be running.

Enable TCP/IP protocol from SQL SERVER Configuration manager

Add failover clustering feature on SQLNode1/2/3

On SQLNode1/2/3  - SQL SERVER Configuration manager

SQL SERVER Service right click, Always on Tab -> 

Enable Always ON Availability Group

Go to – SQLNode1 – Failover cluster manager

Start cluster Setup –Name as swarajcluster

Assign IP for cluster

IP- 10.1.1.14

After cluster setup – you can see entry on DC- Domain Computers

Note:

Cluster Name will be appearing in Roles.

Listener name will be appearing in Roles.

ON SQLNode1 create new AG Group –Availability Group,

Windows server Failover cluster –should be present.

AVGDemonew is the listener – IP 10.1.1.17

Video's Link

Part 1

Part 2

Part 3