{"id":138384,"date":"2023-07-24T11:58:34","date_gmt":"2023-07-24T08:58:34","guid":{"rendered":"https:\/\/computingforgeeks.com\/?p=138384"},"modified":"2023-07-24T11:58:38","modified_gmt":"2023-07-24T08:58:38","slug":"configuring-alwayson-availability-groups-in-sql-server","status":"publish","type":"post","link":"https:\/\/computingforgeeks.com\/configuring-alwayson-availability-groups-in-sql-server\/","title":{"rendered":"Configuring AlwaysOn Availability Groups in SQL Server 2022"},"content":{"rendered":"\n<p>High availability refers to a system or infrastructure&#8217;s ability to remain operational and accessible for an extended period, typically measured as a percentage of uptime. It ensures that critical services or applications are consistently available to users without significant interruptions due to hardware or software failures, scheduled maintenance, or other unforeseen events.<\/p>\n\n\n\n<p>High availability is significant for businesses as it ensures uninterrupted operations, prevents revenue loss, and maintains customer satisfaction. It reduces financial risks, protects reputation, and helps businesses maintain their competitive edge. By incorporating redundancy and fault-tolerant mechanisms, high-availability systems improve overall reliability. Redundant components and load-balancing techniques distribute the workload across resources, ensuring scalability and optimal performance even during peak usage periods.<\/p>\n\n\n\n<p>Databases are crucial components of modern applications and play a vital role in storing, managing, and retrieving data. They serve as the backbone for various business-critical systems, including customer relationship management (CRM), enterprise resource planning (ERP), e-commerce, financial applications, and more. The importance of databases lies in their ability to provide consistent, reliable, and secure access to data.<\/p>\n\n\n\n<p><strong>AlwaysOn Availability Groups<\/strong> is a high availability and disaster recovery feature introduced in Microsoft SQL Server. It provides a solution for database mirroring and failover clustering, allowing you to create a group of databases that can fail over as a single unit.<\/p>\n\n\n\n<p>In the context of high availability, AlwaysOn Availability Groups offer the following benefits to SQL databases:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Increased Uptime<\/strong>: By configuring multiple database replicas, AlwaysOn Availability Groups ensure that your databases remain available even in the event of a failure. If the primary replica becomes unavailable, one of the secondary replicas can be automatically promoted to become the new primary, minimizing downtime.<\/li>\n\n\n\n<li><strong>Redundancy and Fault Tolerance<\/strong>: AlwaysOn Availability Groups provide database redundancy by maintaining synchronized copies of the databases across multiple replicas. These replicas can be hosted on different servers, improving fault tolerance and protecting against hardware or software failures.<\/li>\n\n\n\n<li><strong>Load Balancing and Read-Only Routing<\/strong>: You can configure read-only replicas within an availability group, enabling you to offload read workloads from the primary replica. This load-balancing capability improves performance by distributing read operations across multiple replicas.<\/li>\n\n\n\n<li><strong>Disaster Recovery<\/strong>: AlwaysOn Availability Groups can be used for disaster recovery purposes by configuring replicas in different geographic locations. This allows for automatic or manual failover to the secondary replicas in case of a disaster or planned maintenance, ensuring business continuity.<\/li>\n\n\n\n<li><strong>Scalability and Performance<\/strong>: With the increasing volume of data and user demands, databases need to scale and handle larger workloads efficiently. AlwaysOn Availability Groups offer the ability to distribute read workloads across multiple read-only replicas, allowing for load balancing and improved performance. This scalability feature ensures that the database can handle growing demands without sacrificing responsiveness.<\/li>\n<\/ul>\n\n\n\n<p>This section provides a comprehensive guide on deploying Always On availability groups in SQL Server 2022 instances. It covers the necessary steps and procedures to implement this high-availability feature.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Prerequisites<\/h2>\n\n\n\n<p>For this guide, you need to have Windows Server 2022 Failover Clustering (WSFC) configured. This can be done by following the aid provided here.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/computingforgeeks.com\/configure-windows-server-failover-clustering-wsfc\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Configure Windows Server 2022 Failover Clustering (WSFC)<\/a><\/li>\n<\/ul>\n\n\n\n<p>For my setup, I used 3 servers, configured as shown:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>TASK<\/strong><\/td><td><strong>IP ADDRESS<\/strong><\/td><td><strong>HOSTNAME<\/strong><\/td><\/tr><tr><td>iSCSI Target\/AD DS\/DNS Server<\/td><td>192.168.200.55<\/td><td>win-server.computingforgeeks.com<\/td><\/tr><tr><td>Cluster Node1<\/td><td>192.168.200.70<\/td><td>node1.computingforgeeks.com<\/td><\/tr><tr><td>Cluster Node2<\/td><td>192.168.200.71<\/td><td>node2.computingforgeeks.com<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>You also need to install the SQL Server 2022 with a stand-alone installation and <strong><em>remote authentication<\/em><\/strong> <strong><em>enabled<\/em><\/strong>(able to login with AD user). This can be done by following the below guide:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/computingforgeeks.com\/installing-sql-server-on-windows-server\/\" target=\"_blank\" rel=\"noreferrer noopener\">Install and Configure SQL Server 2022 on Windows Server 2022<\/a><\/li>\n<\/ul>\n\n\n\n<p>Once the prerequisites have been met, proceed to configure the AlwaysOn Availability Groups in SQL Server 2022 with the below steps.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">#1. Add SQL 2022 Instances to the Failover Clustering<\/h2>\n\n\n\n<p>First, open the SQL Server 2022 Configuration Manager on all the nodes, select <strong>SQL Server Services<\/strong>-&gt;<strong>SQL Server (instance name)<\/strong>, right-click and select properties.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"718\" height=\"396\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022.png\" alt=\"\" class=\"wp-image-138684\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022.png 718w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-300x165.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-696x385.png 696w\" sizes=\"auto, (max-width: 718px) 100vw, 718px\" \/><\/figure>\n\n\n\n<p>Navigate to the <strong>Alwayson Availability Groups<\/strong> tab and <strong>check<\/strong> the box to enable the features. Then <strong>restart<\/strong> the SQL server<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"539\" height=\"712\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-1.png\" alt=\"\" class=\"wp-image-138685\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-1.png 539w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-1-227x300.png 227w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-1-318x420.png 318w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><\/figure>\n\n\n\n<p>Next, we need to create a folder for the backup of the database of AlwaysOn Availability Groups and also add full access permission to the SQL Server login user.<\/p>\n\n\n\n<p>Create the data directory with the required permissions.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"741\" height=\"694\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-2.png\" alt=\"\" class=\"wp-image-138686\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-2.png 741w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-2-300x281.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-2-696x652.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-2-448x420.png 448w\" sizes=\"auto, (max-width: 741px) 100vw, 741px\" \/><\/figure>\n\n\n\n<p>Create a backup directory on the C Drive with the name <strong>AlwaysonDB-Backup<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"788\" height=\"727\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-3.png\" alt=\"\" class=\"wp-image-138687\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-3.png 788w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-3-300x277.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-3-768x709.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-3-696x642.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-3-455x420.png 455w\" sizes=\"auto, (max-width: 788px) 100vw, 788px\" \/><\/figure>\n\n\n\n<p>You also need to allow the database mirroring service port through the firewall. Launch <strong>Windows Defender<\/strong>, under the inbound ports, and add a new rule.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"739\" height=\"766\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-4.png\" alt=\"\" class=\"wp-image-138688\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-4.png 739w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-4-289x300.png 289w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-4-696x721.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-4-405x420.png 405w\" sizes=\"auto, (max-width: 739px) 100vw, 739px\" \/><\/figure>\n\n\n\n<p>Add port <strong>5022\/TCP<\/strong> as shown.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"812\" height=\"737\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-5.png\" alt=\"\" class=\"wp-image-138689\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-5.png 812w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-5-300x272.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-5-768x697.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-5-696x632.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-5-463x420.png 463w\" sizes=\"auto, (max-width: 812px) 100vw, 812px\" \/><\/figure>\n\n\n\n<p>Provide the rule name and create it.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">#2. Create the AlwaysOn Database<\/h2>\n\n\n\n<p>Now on the selected Primary Node, you need to accomplish the below steps. First, access the SQL Server Management Studio (SSMS) and create a database for the AlwaysOn Availability Groups. Remember to specify the database path created in Step 1.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"973\" height=\"817\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-6.png\" alt=\"\" class=\"wp-image-138690\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-6.png 973w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-6-300x252.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-6-768x645.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-6-696x584.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-6-500x420.png 500w\" sizes=\"auto, (max-width: 973px) 100vw, 973px\" \/><\/figure>\n\n\n\n<p>Once the database has been created, take a backup by right-clicking on it and proceeding as shown.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"979\" height=\"690\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-7.png\" alt=\"\" class=\"wp-image-138691\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-7.png 979w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-7-300x211.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-7-768x541.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-7-696x491.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-7-596x420.png 596w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-7-100x70.png 100w\" sizes=\"auto, (max-width: 979px) 100vw, 979px\" \/><\/figure>\n\n\n\n<p>Proceed and remove the available default backup path to allow us to specify a desired path.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"668\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-8-1024x668.png\" alt=\"\" class=\"wp-image-138692\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-8-1024x668.png 1024w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-8-300x196.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-8-768x501.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-8-696x454.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-8-643x420.png 643w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-8.png 1060w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Set the created Path as the backup directory, and provide the name for the backup.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"757\" height=\"843\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-9.png\" alt=\"\" class=\"wp-image-138693\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-9.png 757w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-9-269x300.png 269w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-9-696x775.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-9-377x420.png 377w\" sizes=\"auto, (max-width: 757px) 100vw, 757px\" \/><\/figure>\n\n\n\n<p>Once complete, you will see this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"748\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-10-1024x748.png\" alt=\"\" class=\"wp-image-138694\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-10-1024x748.png 1024w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-10-300x219.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-10-768x561.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-10-696x508.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-10-575x420.png 575w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-10.png 1054w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">#3. Create the Availability Groups in SQL Server 2022<\/h2>\n\n\n\n<p>Access the database on the<strong> Primary node<\/strong> using SQL Server Management Studio (SSMS) with the domain user\/user set as the admin account for the SQL server.<\/p>\n\n\n\n<p>Right-click on the <strong>Always On High Availability<\/strong>-&gt;<strong>Availability Groups<\/strong>, launch the <strong><em>New Availability Group Wizard<\/em><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"779\" height=\"546\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-11.png\" alt=\"\" class=\"wp-image-138695\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-11.png 779w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-11-300x210.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-11-768x538.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-11-696x488.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-11-599x420.png 599w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-11-100x70.png 100w\" sizes=\"auto, (max-width: 779px) 100vw, 779px\" \/><\/figure>\n\n\n\n<p>Click <strong>Next<\/strong> to proceed<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"944\" height=\"886\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-12.png\" alt=\"\" class=\"wp-image-138696\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-12.png 944w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-12-300x282.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-12-768x721.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-12-696x653.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-12-447x420.png 447w\" sizes=\"auto, (max-width: 944px) 100vw, 944px\" \/><\/figure>\n\n\n\n<p>Provide the name for the <strong><em>Availability group<\/em><\/strong> you want to create:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"944\" height=\"886\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-13.png\" alt=\"\" class=\"wp-image-138697\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-13.png 944w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-13-300x282.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-13-768x721.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-13-696x653.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-13-447x420.png 447w\" sizes=\"auto, (max-width: 944px) 100vw, 944px\" \/><\/figure>\n\n\n\n<p>Select the database we created earlier for the Alwayson availability group.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"944\" height=\"886\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-14.png\" alt=\"\" class=\"wp-image-138698\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-14.png 944w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-14-300x282.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-14-768x721.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-14-696x653.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-14-447x420.png 447w\" sizes=\"auto, (max-width: 944px) 100vw, 944px\" \/><\/figure>\n\n\n\n<p>Specify the replicas by clicking the <strong>Add Replica<\/strong> button.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"944\" height=\"886\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-16.png\" alt=\"\" class=\"wp-image-138700\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-16.png 944w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-16-300x282.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-16-768x721.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-16-696x653.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-16-447x420.png 447w\" sizes=\"auto, (max-width: 944px) 100vw, 944px\" \/><\/figure>\n\n\n\n<p>Once all the Replicas have been added, you will see this.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"944\" height=\"886\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-17.png\" alt=\"\" class=\"wp-image-138701\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-17.png 944w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-17-300x282.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-17-768x721.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-17-696x653.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-17-447x420.png 447w\" sizes=\"auto, (max-width: 944px) 100vw, 944px\" \/><\/figure>\n\n\n\n<p>Now proceed to the <strong>listeners<\/strong> tab, here provide a preferred name for the listener in the Listener DNS Name field, provide the listening port and set a static IP address for the listener as shown:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"944\" height=\"886\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-19.png\" alt=\"\" class=\"wp-image-138703\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-19.png 944w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-19-300x282.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-19-768x721.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-19-696x653.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-19-447x420.png 447w\" sizes=\"auto, (max-width: 944px) 100vw, 944px\" \/><\/figure>\n\n\n\n<p>Set the preferred data synchronization method. The default selection is <strong><em>Automatic seeding<\/em><\/strong>, which is still okay.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"944\" height=\"886\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-18.png\" alt=\"\" class=\"wp-image-138702\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-18.png 944w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-18-300x282.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-18-768x721.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-18-696x653.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-18-447x420.png 447w\" sizes=\"auto, (max-width: 944px) 100vw, 944px\" \/><\/figure>\n\n\n\n<p>Validate the made configs. If all is okay, proceed.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"944\" height=\"886\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-20.png\" alt=\"\" class=\"wp-image-138704\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-20.png 944w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-20-300x282.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-20-768x721.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-20-696x653.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-20-447x420.png 447w\" sizes=\"auto, (max-width: 944px) 100vw, 944px\" \/><\/figure>\n\n\n\n<p>A summary of the made settings will be provided<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"944\" height=\"886\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-21.png\" alt=\"\" class=\"wp-image-138705\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-21.png 944w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-21-300x282.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-21-768x721.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-21-696x653.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-21-447x420.png 447w\" sizes=\"auto, (max-width: 944px) 100vw, 944px\" \/><\/figure>\n\n\n\n<p>Once finished, you will be able to view the status of the Availability group by selecting<strong> show dashboard <\/strong>as shown:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"645\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-24-1024x645.png\" alt=\"\" class=\"wp-image-138708\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-24-1024x645.png 1024w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-24-300x189.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-24-768x484.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-24-696x439.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-24-1068x673.png 1068w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-24-667x420.png 667w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-24.png 1184w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>You can also verify access by connecting to the listener using <code>sqlcmd<\/code> as shown:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sqlcmd -S listener01 -Q \"select @@servername\"\n##OR\nsqlcmd -S 192.168.200.75 -Q \"select @@servername\"<\/code><\/pre>\n\n\n\n<p>Sample output:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"420\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-26-1024x420.png\" alt=\"\" class=\"wp-image-138707\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-26-1024x420.png 1024w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-26-300x123.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-26-768x315.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-26-696x285.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-26-1068x438.png 1068w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-26.png 1107w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">#4. Configure Failover Cluster on SQL Server 2022<\/h2>\n\n\n\n<p>Configuring the Failover Cluster on SQL Server 2022 involves running Server failover cluster installation on all the nodes. For this guide, we will have two phases.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">a. Configure Failover Cluster on SQL Server 2022 on Primary Node<\/h3>\n\n\n\n<p>After following all the above steps of configuring WSFC, installing the SQL server 2022, and creating users for remote authentication, we come to yet another stage.<\/p>\n\n\n\n<p>Here, we will run the SQL Server installation program on the selected Primary node and select the <strong>New SQL Server failover cluster installation<\/strong> option.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"925\" height=\"784\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-27.png\" alt=\"\" class=\"wp-image-138709\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-27.png 925w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-27-300x254.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-27-768x651.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-27-696x590.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-27-496x420.png 496w\" sizes=\"auto, (max-width: 925px) 100vw, 925px\" \/><\/figure>\n\n\n\n<p>Ensure that you pass this validation. If you encounter issues with the <strong><em>Microsoft Cluster Service<\/em><\/strong>(MCS), all you need is to obtain a good report by validating your cluster(You can bypass the services causing errors during cluster validation). If all is well, you will see this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"975\" height=\"941\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-29.png\" alt=\"\" class=\"wp-image-138710\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-29.png 975w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-29-300x290.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-29-768x741.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-29-696x672.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-29-435x420.png 435w\" sizes=\"auto, (max-width: 975px) 100vw, 975px\" \/><\/figure>\n\n\n\n<p>Select the features to be installed as shown:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"721\" height=\"761\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-30.png\" alt=\"\" class=\"wp-image-138711\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-30.png 721w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-30-284x300.png 284w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-30-696x735.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-30-398x420.png 398w\" sizes=\"auto, (max-width: 721px) 100vw, 721px\" \/><\/figure>\n\n\n\n<p>Configure the <strong><em>SQL Server Network Name<\/em><\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"830\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-31.png\" alt=\"\" class=\"wp-image-138712\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-31.png 969w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-31-300x257.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-31-768x658.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-31-696x596.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-31-490x420.png 490w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/><\/figure>\n\n\n\n<p>Set Cluster Resource Group.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"982\" height=\"930\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-32.png\" alt=\"\" class=\"wp-image-138713\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-32.png 982w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-32-300x284.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-32-768x727.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-32-696x659.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-32-443x420.png 443w\" sizes=\"auto, (max-width: 982px) 100vw, 982px\" \/><\/figure>\n\n\n\n<p>Choose the cluster disk for the SQL Server Databases. Here you can select the shared storage set for the cluster.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"982\" height=\"930\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-33.png\" alt=\"\" class=\"wp-image-138714\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-33.png 982w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-33-300x284.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-33-768x727.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-33-696x659.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-33-443x420.png 443w\" sizes=\"auto, (max-width: 982px) 100vw, 982px\" \/><\/figure>\n\n\n\n<p>Set the cluster network and provide an available IP for the SQL Server Failover Cluster Instance<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"877\" height=\"929\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-34.png\" alt=\"\" class=\"wp-image-138715\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-34.png 877w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-34-283x300.png 283w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-34-768x814.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-34-696x737.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-34-396x420.png 396w\" sizes=\"auto, (max-width: 877px) 100vw, 877px\" \/><\/figure>\n\n\n\n<p>Configure the service accounts, and set the admin users for the SQL Server Database Engine and SQL Server Agent service<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"941\" height=\"881\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-35.png\" alt=\"\" class=\"wp-image-138716\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-35.png 941w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-35-300x281.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-35-768x719.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-35-696x652.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-35-449x420.png 449w\" sizes=\"auto, (max-width: 941px) 100vw, 941px\" \/><\/figure>\n\n\n\n<p>Proceed with the rest of the steps as we did for the stand-alone installation.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">b. Configure Failover Cluster on SQL Server 2022 on Secondary Nodes<\/h3>\n\n\n\n<p>On the secondary nodes, we need to install the SQL Server Failover Cluster Instance as well. Run the SQL Server installer and select the <strong>Add node to a SQL Server failover cluster<\/strong> option<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"874\" height=\"811\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-36.png\" alt=\"\" class=\"wp-image-138717\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-36.png 874w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-36-300x278.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-36-768x713.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-36-696x646.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-36-453x420.png 453w\" sizes=\"auto, (max-width: 874px) 100vw, 874px\" \/><\/figure>\n\n\n\n<p>Perform system checks:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"877\" height=\"929\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-37.png\" alt=\"\" class=\"wp-image-138718\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-37.png 877w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-37-283x300.png 283w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-37-768x814.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-37-696x737.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-37-396x420.png 396w\" sizes=\"auto, (max-width: 877px) 100vw, 877px\" \/><\/figure>\n\n\n\n<p>Provide the node settings for the cluster as shown. The cluster should be detected automatically as shown.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"877\" height=\"929\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-38.png\" alt=\"\" class=\"wp-image-138719\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-38.png 877w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-38-283x300.png 283w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-38-768x814.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-38-696x737.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-38-396x420.png 396w\" sizes=\"auto, (max-width: 877px) 100vw, 877px\" \/><\/figure>\n\n\n\n<p>Configure the cluster network, the available cluster should be detected.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"877\" height=\"929\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-39.png\" alt=\"\" class=\"wp-image-138720\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-39.png 877w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-39-283x300.png 283w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-39-768x814.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-39-696x737.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-39-396x420.png 396w\" sizes=\"auto, (max-width: 877px) 100vw, 877px\" \/><\/figure>\n\n\n\n<p>Next, configure the service accounts. The services set on the Primary node will be detected, so provide the <strong>passwords<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"878\" height=\"928\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-40.png\" alt=\"\" class=\"wp-image-138721\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-40.png 878w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-40-284x300.png 284w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-40-768x812.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-40-696x736.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-40-397x420.png 397w\" sizes=\"auto, (max-width: 878px) 100vw, 878px\" \/><\/figure>\n\n\n\n<p>Now proceed with similar steps as for the stand-alone installation. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"878\" height=\"928\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-42.png\" alt=\"\" class=\"wp-image-138723\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-42.png 878w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-42-284x300.png 284w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-42-768x812.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-42-696x736.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-42-397x420.png 397w\" sizes=\"auto, (max-width: 878px) 100vw, 878px\" \/><\/figure>\n\n\n\n<p>Once complete, the role will now be available on the WSFC management as shown:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"989\" height=\"896\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-43.png\" alt=\"\" class=\"wp-image-138724\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-43.png 989w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-43-300x272.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-43-768x696.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-43-696x631.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-43-464x420.png 464w\" sizes=\"auto, (max-width: 989px) 100vw, 989px\" \/><\/figure>\n\n\n\n<p>From here, you can take note of the Cluster Network name. For this case it is <strong><em>MSSQL-CLUSTER1<\/em><\/strong> and use it for connection as shown below.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">#5. Test AlwaysOn Availability Groups in SQL Server 2022<\/h2>\n\n\n\n<p>Now to test if everything is working, we can try login to the SQL server using the SQL Server<strong> Network Name<\/strong>. This can be done using the SSMS as shown.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"989\" height=\"896\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-44.png\" alt=\"\" class=\"wp-image-138725\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-44.png 989w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-44-300x272.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-44-768x696.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-44-696x631.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-44-464x420.png 464w\" sizes=\"auto, (max-width: 989px) 100vw, 989px\" \/><\/figure>\n\n\n\n<p>Once connected, you should see this.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"995\" height=\"927\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-45.png\" alt=\"\" class=\"wp-image-138726\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-45.png 995w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-45-300x279.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-45-768x716.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-45-696x648.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-45-451x420.png 451w\" sizes=\"auto, (max-width: 995px) 100vw, 995px\" \/><\/figure>\n\n\n\n<p>You can also view the database and availability groups:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"769\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-46-1024x769.png\" alt=\"\" class=\"wp-image-138727\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-46-1024x769.png 1024w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-46-300x225.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-46-768x577.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-46-696x523.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-46-1068x802.png 1068w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-46-559x420.png 559w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-46-80x60.png 80w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-46-265x198.png 265w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2023\/05\/Configuring-AlwaysOn-Availability-Groups-in-SQL-Server-2022-46.png 1234w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Verdict<\/h2>\n\n\n\n<p>That is it for now how to configure AlwaysOn Availability Groups in SQL Server 2022. I hope this worked for you too.<\/p>\n\n\n\n<p>See more on this page:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/computingforgeeks.com\/run-microsoft-sql-server-in-docker-podman-container\/\" target=\"_blank\" rel=\"noreferrer noopener\">Run Microsoft SQL Server 2022 in Docker \/ Podman Container<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/computingforgeeks.com\/install-microsoft-sql-server-on-ubuntu\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Install Microsoft SQL Server&nbsp;2022 on Ubuntu 20.04<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/computingforgeeks.com\/install-microsoft-sql-server-rocky-almalinux\/\" target=\"_blank\" rel=\"noreferrer noopener\">Install Microsoft SQL Server 2022 on Rocky Linux 8 \/ AlmaLinux 8<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>High availability refers to a system or infrastructure&#8217;s ability to remain operational and accessible for an extended period, typically measured as a percentage of uptime. It ensures that critical services or applications are consistently available to users without significant interruptions due to hardware or software failures, scheduled maintenance, or other unforeseen events. High availability is &#8230; <a title=\"Configuring AlwaysOn Availability Groups in SQL Server 2022\" class=\"read-more\" href=\"https:\/\/computingforgeeks.com\/configuring-alwayson-availability-groups-in-sql-server\/\" aria-label=\"Read more about Configuring AlwaysOn Availability Groups in SQL Server 2022\">Read more<\/a><\/p>\n","protected":false},"author":21,"featured_media":138691,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[461,299,90],"tags":[38693],"class_list":["post-138384","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-how-to","category-windows","tag-alwayson-availability-groups"],"_links":{"self":[{"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/posts\/138384","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/comments?post=138384"}],"version-history":[{"count":0,"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/posts\/138384\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/media\/138691"}],"wp:attachment":[{"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/media?parent=138384"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/categories?post=138384"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/tags?post=138384"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}