Powershell/sql-Install.ps1 at master · du5tylane/Powershell · 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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
##################################
##  SQL Install                 ##
##################################

#Region Parameters

# The typical parameters that are changed are the paths - update below as necessary

$SQLInstallFrom = "B:"
$SQLUSERDBDIR="E:\MSSQL\Data"
$SQLUSERDBLOGDIR="G:\MSSQL\Data"
$SQLTEMPDBDIR="F:\MSSQL\Data"
$SQLTEMPDBLOGDIR="H:\MSSQL\Data"
$INSTANCEDIR="d:\Program Files\Microsoft SQL Server"
$INSTALLSHAREDDIR="d:\Program Files\Microsoft SQL Server"
$INSTALLSHAREDWOWDIR="d:\Program Files (x86)\Microsoft SQL Server"
#EndRegion


$configuration = @"
;SQL Server 2017 Configuration File
[OPTIONS]
IAcceptSQLServerLicenseTerms="True"
ACTION="Install"
SUPPRESSPRIVACYSTATEMENTNOTICE="True"
IACCEPTROPENLICENSETERMS="True"
ENU="True"
UpdateEnabled="False"
FEATURES=SQLENGINE,REPLICATION,DQC,CONN,IS,BC,SDK,SNAC_SDK
INSTANCENAME="MSSQLSERVER"
INSTALLSHAREDDIR=$INSTALLSHAREDDIR
INSTALLSHAREDWOWDIR=$INSTALLSHAREDWOWDIR
INSTANCEID="MSSQLSERVER"
SQLTELSVCACCT="NT Service\SQLTELEMETRY"
SQLTELSVCSTARTUPTYPE="Automatic"
ISTELSVCACCT="NT Service\SSISTELEMETRY140"
ISTELSVCSTARTUPTYPE="Automatic"
INSTANCEDIR=$INSTANCEDIR
AGTSVCACCOUNT="NT Service\SQLSERVERAGENT"
AGTSVCSTARTUPTYPE="Automatic"
ISSVCSTARTUPTYPE="Automatic"
ISSVCACCOUNT="NT Service\MsDtsServer140"
SQLSVCSTARTUPTYPE="Automatic"
FILESTREAMLEVEL="0"
SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"
SQLSVCACCOUNT="NT Service\MSSQLSERVER"
SQLSVCINSTANTFILEINIT="True"
SQLSYSADMINACCOUNTS="BUILTIN\Administrators"
SECURITYMODE="SQL"
SQLTEMPDBFILECOUNT="2"
SQLTEMPDBFILESIZE="8"
SQLTEMPDBFILEGROWTH="64"
SQLTEMPDBLOGFILESIZE="8"
SQLTEMPDBLOGFILEGROWTH="64"
SQLUSERDBDIR=$SQLUSERDBDIR
SQLUSERDBLOGDIR=$SQLUSERDBLOGDIR
SQLTEMPDBDIR=$SQLTEMPDBDIR
SQLTEMPDBLOGDIR=$SQLTEMPDBLOGDIR
TCPENABLED="1"
"@

$configuration | Out-File -FilePath $env:temp\SQL_ConfigurationFile.INI -Encoding ascii -Force

# Install SQL Server
Invoke-Command -ScriptBlock {
    Start-Process -FilePath "$($SQLInstallFrom)\setup.exe" -ArgumentList "/q /SAPWD='MySecurePW123!' /ConfigurationFile=$($env:temp)\SQL_ConfigurationFile.INI" -NoNewWindow -PassThru -Wait
}