Configuring AlwaysOn Availability Groups on SQL Server

Image for post
Image for post

INTRODUCTION

PREREQUISITES

1.1 Prerequisites

SUMMARY

1.2 The configuration procedure involves the following stages:

PROCEDURE

1.3 Enable Clustering on All Nodes

Image for post
Image for post
Figure 1: Add Roles and Features
Image for post
Image for post
Figure 2
Image for post
Image for post
Figure 3
Image for post
Image for post
Figure 4
Image for post
Image for post
Figure 5. Server Roles
Image for post
Image for post
Figure 6: Server Features
Image for post
Image for post
Figure 7

1.4 Validate the Servers for Clustering

Image for post
Image for post
Figure 8: Validate Configuration
Image for post
Image for post
Figure 9
Image for post
Image for post
Figure 10
Image for post
Image for post
Figure 11
Image for post
Image for post
Figure 12
Image for post
Image for post
Figure 13. Validated Tests
Image for post
Image for post
Figure 14

1.5 Create a Cluster

Image for post
Image for post
Figure 15. Create Cluster
Image for post
Image for post
Figure 16
Image for post
Image for post
Figure 17
Image for post
Image for post
Figure 18
Image for post
Image for post
Figure 19
Image for post
Image for post
Figure 20
Image for post
Image for post
Figure 21

1.6 Configure Quorum

Image for post
Image for post
Figure 22
Image for post
Image for post
Figure 23
Image for post
Image for post
Figure 24
Image for post
Image for post
Figure 25
Image for post
Image for post
Figure 26
Image for post
Image for post
Figure 27
Image for post
Image for post
Figure 28
Image for post
Image for post
Figure 29
Image for post
Image for post
Figure 30
Image for post
Image for post
Figure 31

1.7 Install the SQL Server

1.8 Enable AlwaysOn Availability Groups

Image for post
Image for post
Figure 32
Image for post
Image for post
Figure 33

1.9 Create a New Availability Group

Image for post
Image for post
Figure 34
Image for post
Image for post
Figure 35
Image for post
Image for post
Figure 36
Image for post
Image for post
Figure 37
Image for post
Image for post
Figure 38
Image for post
Image for post
Figure 39
Image for post
Image for post
Figure 40
Image for post
Image for post
Figure 41
Image for post
Image for post
Figure 42
Image for post
Image for post
Figure 43
Image for post
Image for post
Figure 44

1.10 Add an AG Listener

Image for post
Image for post
Figure 45
Image for post
Image for post
Figure 46
Image for post
Image for post
Figure 47

1.11 Issues Faced

Image for post
Image for post
Figure 48
Image for post
Image for post
Figure 49

1.12 References

Written by

Awesome blog focused on databases and Microsoft, .NET and cloud technologies. http://codingsight.com/

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store