Which mode must be used for Always On Availability Group clustering?

Windows Authentication allows users to connect to SQL Server using their Windows credentials. It

uses Kerberos security protocol for authentication and it's considered more secure than SQL Server

Authentication.

Always On Availability Groups (AGs) is a feature of Microsoft SQL Server that provides high

availability and disaster recovery for a group of user databases. Windows Authentication is required

for all the SQL Server instances that participate in an availability group.

It's important to note that, the specific configuration options and settings may vary depending on the

version of SQL Server and the specific requirements of the organization. It's recommended to consult

the Microsoft documentation and your SQL Server support team for further assistance.

Reference:

Microsoft: Always On Availability Groups (SQL Server)

Microsoft: Configure the Server Authentication Mode

Microsoft: Connect to the Primary Replica of an Always On Availability Group (SQL Server)