Skip to content

Instantly share code, notes, and snippets.

@nyanhp
Created November 22, 2017 17:27
Show Gist options
  • Save nyanhp/dac9ce0cae4e4e48b2a91109d7a6365d to your computer and use it in GitHub Desktop.
Save nyanhp/dac9ce0cae4e4e48b2a91109d7a6365d to your computer and use it in GitHub Desktop.
A small lab to set up two domain-joined cluster nodes with an installation of SQL Server 2016
New-LabDefinition -Name FailoverLab -DefaultVirtualizationEngine HyperV
Add-LabDomainDefinition -Name contoso.com -AdminUser Install -AdminPassword Somepass1
Set-LabInstallationCredential -Username Install -Password Somepass1
Add-LabIsoImageDefinition -Name SQLServer2016 -Path $labsources\ISOS\en_sql_server_2016_enterprise_x64_dvd_8701793.iso
$PSDefaultParameterValues = @{
'Add-LabMachineDefinition:DomainName' = 'contoso.com'
'Add-LabMachineDefinition:Memory' = 1GB
'Add-LabMachineDefinition:OperatingSystem' = 'Windows Server 2016 SERVERDATACENTER'
}
Add-LabMachineDefinition -Name CLUDC01 -Roles RootDC
$roles = @(
Get-LabMachineRoleDefinition -Role FailoverNode
Get-LabMachineRoleDefinition -Role SQLServer2016 -Properties @{SQLSvcAccount = 'sql2016usr'; SQLSvcPassword = 'A super c0mplex Passw0rd!'; InstallSampleDatabase = 'true'}
)
Add-LabMachineDefinition -Name CLUN01-01 -Roles $roles
Add-LabMachineDefinition -Name CLUN01-02 -Roles $roles
Install-Lab
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment