Title

Deploy Windows Server Failover Cluster and Setup the MS SQL Server AOAG in Compute Instance

About Or Title

About This Workshop

Desc Long

This hands-on workshop provides users with step-by-step instructions on deploying the WSFC (Windows Server Failover Clustering) and configuring the Microsoft SQL Server Always On Availability Group setup.

Workshop Length

5 hours

Outline

Setup the windows Active directory in Compute Instance
Provisioning the Compute Instance from Market Place Image for SQL Server 2019.
Setup the 2 node Windows Server Failover cluster in Compute Instance
Setup and Configure the Microsoft SQL Server Always on Availability group setup.
Setup Windows Witness server for Windows Server Failover Cluster

Prerequisites

An Oracle Free Tier, Always Free, Paid, or LiveLabs Cloud Account
Some understanding of cloud and security terms is helpful.
Familiarity with Oracle Cloud Infrastructure (OCI) is helpful.
Required Subnets: One public subnet for the Bastion host and three private subnets to host the Domain Controller, Microsoft SQL Server Nodes, and Quorum Server

Other Workshops you might like

Kick off your Oracle Cloud Part 1

Kick off your Oracle Cloud Part 1

Explore basic OCI services: Networking, Compute, Storage and more.

1 hr, 30 mins 11660 Views
Explore the Oracle Insurance Policy Administration (OIPA) platform

Explore the Oracle Insurance Policy Administration (OIPA) platform

OIPA product team would like to provide their customer capability to create sandbox on OIPA and (..)

2 hrs 767 Views
Migrating Microsoft SQL Server Analysis Service (SSAS) Databases to OCI

Migrating Microsoft SQL Server Analysis Service (SSAS) Databases to OCI

In this Livelab, Anyone can learn how to migrate SSAS DB's from On-Premise to OCI (Compute Instance)

1 hr, 30 mins
Manage and Monitor Autonomous Database

Manage and Monitor Autonomous Database

Provision an Oracle Autonomous Database and perform basic monitoring and management tasks.

3 hrs 64029 Views