PCfromDC

# Array of Domain Controller Server Names
$DCs = @("DC01","DC02","DC03")

# Database Server
$dbServer = "sql2012-03"

# Database Name
$databaseName = "pcDemo_Personnel"

# Production System User Table Name

PCfromDC

$nodeName = "SQL03"

Configuration SQL2014 {

    param ($nodeName)

    Node $nodeName {

#region Set Parameters
        $isoName = "en_sql_server_2014_enterprise_edition_x64_dvd_3932700.iso"

PCfromDC

# Active Directory Module for PowerShell feature needs to be installed
# spAccounts.csv can be downloaded from: http://1drv.ms/1bHTZC0

Import-Module ActiveDirectory -EA 0

# Create AD Users and Groups

#region Parameters

$file = "C:\DevOps\Microsoft\SQL Server 2014\config\spAccounts.csv"

PCfromDC

$domain = "contoso.local"
$newName ="SQL03"
$OUPath = # to put computer in specific OU
$prefixLength = 24 # PrefixLength of 24 equals a subnet mask of 255.255.255.0

# Update Description
Write-Host -ForegroundColor Green "Updating server description..."
$desc = Get-WmiObject -Class Win32_OperatingSystem
$desc.Description = $newName
$desc.put() 

PCfromDC

$serverName = "SQL03"
$vmName = "3- SQL03"
$vmDest= "G:\VMs\$serverName\"
$isoName = "z_Master-Server2012R2-Standard.vhdx"
$isoPath = "D:\_Images\"
# VM Host Name
$computerName = "Host-HP-01"
# Network 
$switchName = "pcDemo-1"

PCfromDC

#region Create Server 2012R2 Features Array
    function getServer2012R2Features {
        $windows2012R2Features = @(
            "Application-Server",
            "AS-NET-Framework",
            "AS-Web-Support",
            "FileAndStorage-Services",
            "Storage-Services",
            "Web-Server",
            "Web-WebServer",

PCfromDC

Import-Module BitsTransfer

$destPath = "C:\tempDownloads" # Change this to desired download destination path
$destPath = $destPath.TrimEnd('\')

#region validate download path
    function validatePath($destFolder){
        ## Check that the path entered is valid
        If (!(Test-Path $destFolder -Verbose)) {
            New-Item -Path $destFolder -ItemType Directory

PCfromDC

# set varibles
$sp2016Location = "D:\"  # Change to folder location of SharePoint prerequisiteinstaller.exe file
$destPath = "C:\tempDownloads"
$sp2016preReqPath = Get-Content "$destPath\sp2016preReqPath.txt"

Import-Module Servermanager

#region Create variable paths and copy files
    $sp2016preReqPath = $sp2016preReqPath.TrimEnd('\')
    $sp2016Location = $sp2016Location.TrimEnd('\')

PCfromDC

#Get Backup Path
$bkdir = read-host("Enter Folder Location eg: (C:\temp)") # Get Backup Path!
if ($bkdir.EndsWith("\")){$bkdir = $bkdir.TrimEnd("\")}

# Set Backup Path if you want to hard code your path
#$bkdir = "\\serverName\Shared\Temp" (optional "C:\Temp")

# Verify folder exists
if ((test-path $bkdir) -eq $false ) # Verify folder else create it...
  {

PCfromDC

$destPath = "C:\tempDownloads"
$sp2016preReqPath = Get-Content "$destPath\sp2016preReqPath.txt"
Start-Process "$sp2016preReqPath\PrerequisiteInstaller.exe" -ArgumentList ("/continue /unattended") -Wait