sharepoint2013-dev/02_01_SysPrepSqlServer.ps1 at master · asksven/sharepoint2013-dev · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
# by Sven Knispel under ter terms of the Ms-PL license (see license.txt)
#
# syspreps MSSQLServer
#
# History
# 1.0 	2014-01-03 	Initial version
# 1.1	2014-02-14	Externalized config
########################################################################
Get-Content "config.txt" | foreach-object -begin {$h=@{}} -process { $k = [regex]::split($_,'='); if(($k[0].CompareTo("") -ne 0) -and ($k[0].StartsWith("[") -ne $True)) { $h.Add($k[0], $k[1]) } }

# basic path and ISO info
$developerFolderPath = $h.developerFolderPath
$softwareSetupPath = $h.softwareSetupPath
$sqlSetupPath = [STRING]::Concat($softwareSetupPath, $h.sqlSetupPath)

$caAuthProvider = $h.caAuthProvider


Write-Host "(VM) $(Get-Date): Start to sysprep SQL Server."

$sqlService = Get-Service -Name MSSQLSERVER -ErrorAction Ignore


if(!$sqlService)
{
    # Configure SQL Server using Local System account

    if (-Not(Test-Path $sqlSetupPath))
    {
        Write-Host "(VM) $(Get-Date): $sqlSetupPath does not exist"
        exit 1
    }
    $psExecPath = Join-Path -Path $developerFolderPath "tools\PsExec.exe"
    $psExecLogPath = Join-Path -Path $developerFolderPath "tools\PsExecLog.txt"
    $sqlarguments = ' /q /ACTION=PrepareImage /UpdateEnabled /UpdateSource=MU /FEATURES=SQLENGINE /INSTANCEID=MSSQLSERVER /IACCEPTSQLSERVERLICENSETERMS'

    $arguments = $sqlSetupPath + $sqlarguments


    $process = Start-Process -NoNewWindow -FilePath $psExecPath -ArgumentList $arguments -Wait -PassThru

}
else
{
    Write-Host "(VM) $(Get-Date): SQL Server has already been configured."
}


return 0