Created
November 22, 2017 17:27
-
-
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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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