Skip to content

PowerShell Scripts to automate SQL Server AlwaysOn Configuration

Notifications You must be signed in to change notification settings

rlevchenko/powershell-sql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Automate SQL Server AlwaysOn configuration

PowerShell scripts to install SQL Server on both nodes and configure WSFC with AlwaysOn feature. Tested and verified with SQL Server 2012, however, works with later versions as well (some minor changes might be required). The scripts were used as a part of VMM templates, so args are used in some places. Provide just your values instead.

  • Domain.cr : custom resource with PS script that adds machine to the domain
  • SQLInstall.cr : custom resource with PS scripts to install and configure SQL Server
  • SQLInstall2.cr : custom resource with PS scripts to install and configure a second SQL Server node
  • Result: 2 SQL Servers running in the AlwaysOn-enabled cluster

Releases

No releases published

Packages

No packages published