Create SQL Server Availability Test Environment in Azure

Links

Exchange dev/test environments in Azure

Tutorial: Manually configure an availability group

Requirements

Create Azure Account

Create Free Azure Account

Install Azure Az Powershell Module

Install the Azure Az PowerShell module

Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope CurrentUser
Install-Module -Name Az -Scope CurrentUser -Repository PSGallery -Force

How to

Clone this repository

git clone https://github.com/bohlrich/SQLAOAGAZURE.git

Connect to your Azure Account

Connect-AzAccount

Set your Variables in Powershell Scripts

Set $subscrName, $rgName, $locName and $saName in 01 and 03

Execute the first Script

.\01_createEnvironment.ps1

Connect to the adVM and Execute the second Script there

• Connect with mstsc to the Azure Virtual Machine with the given Account
• Open PowerShell
• Execute the contents of 02_createActiveDirectory.ps1
• Restart Machine

Execute the third Script

.\03_createSQLMachines.ps1