; SQL Server 2019 Configuration File
[OPTIONS]
; Accept the SQL Server License Agreement
IACCEPTSQLSERVERLICENSETERMS
; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE.
; This is a required parameter.
ACTION="Install"
; Setup will display progress only, without any user interaction.
QUIETSIMPLE="True"
; Specifies features to install, uninstall, or upgrade.
FEATURES=SQLENGINE,REPLICATION,CONN
; Specify a default or named instance. MSSQLSERVER is the default instance for
; non-Express editions and SQLExpress is for Express editions. This parameter is
; required when installing the SQL Server Database Engine (SQL), Analysis
; Services (AS)
INSTANCENAME="PROSQLADMINCONF1"
; Agent account name
AGTSVCACCOUNT="MyDomain\SQLServiceAccount1"
; Agent account password
AGTSVCPASSWORD="Pa$$w0rd"
; Auto-start service after installation.
AGTSVCSTARTUPTYPE="Automatic"
; Level to enable FILESTREAM feature at (0, 1, 2 or 3).
FILESTREAMLEVEL="1"
; Specifies a Windows collation or an SQL collation to use for the Database
; Engine.
SQLCOLLATION="Latin1_General_CI_AS"
; Account for SQL Server service: Domain\User or system account.
SQLSVCACCOUNT="MyDomain\SQLServiceAccount1"
; Password for the SQL Server service account.
SQLSVCPASSWORD="Pa$$w0rd"
; Windows account(s) to provision as SQL Server system administrators.
SQLSYSADMINACCOUNTS="MyDomain\SQLDBA"
; Specify 0 to disable or 1 to enable the TCP/IP protocol.
TCPENABLED="1"
; Specify 0 to disable or 1 to enable the Named Pipes protocol.
NPENABLED="1"

.\setup.exe /CONFIGURATIONFILE="c:\SQL2019\Configuration1.ini"

;SQL Server 2019 Configuration File
[OPTIONS]
; Accept the SQL Server License Agreement
IACCEPTSQLSERVERLICENSETERMS
; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE.
; This is a required parameter.
ACTION="Install"
; Setup will display progress only, without any user interaction.
QUIETSIMPLE="True"
; Specifies features to install, uninstall, or upgrade.
FEATURES=SQLENGINE,REPLICATION,CONN
; Auto-start service after installation.
AGTSVCSTARTUPTYPE="Automatic"
; Level to enable FILESTREAM feature at (0, 1, 2 or 3).
FILESTREAMLEVEL="1"
; Specifies a Windows collation or an SQL collation to use for the Database Engine.
SQLCOLLATION="Latin1_General_CI_AS"
; Windows account(s) to provision as SQL Server system administrators.
SQLSYSADMINACCOUNTS="MyDomain\SQLDBA"
; Specify 0 to disable or 1 to enable the TCP/IP protocol.
TCPENABLED="1"
; Specify 0 to disable or 1 to enable the Named Pipes protocol.
NPENABLED="1"

.\SETUP.EXE /INSTANCENAME="PROSQLADMINCONF2"
/SQLSVCACCOUNT="MyDomain\SQLServiceAccount1"
/SQLSVCPASSWORD="Pa$$w0rd"
/AGTSVCACCOUNT="MyDomain\SQLServiceAccount1"
/AGTSVCPASSWORD="Pa$$w0rd"
/CONFIGURATIONFILE="C:\SQL2019\Configuration2.ini"

param(
[string] $InstanceName,
[string] $SQLServiceAccount,
[string] $SQLServiceAccountPassword,
[string] $AgentServiceAccount,
[string] $AgentServiceAccountPassword
)
D:\SETUP.EXE /INSTANCENAME=$InstanceName
/SQLSVCACCOUNT=$SQLServiceAccount
/SQLSVCPASSWORD=$SQLServiceAccountPassword
/AGTSVCACCOUNT=$AgentServiceAccount
/AGTSVCPASSWORD=$AgentServiceAccountPassword
/CONFIGURATIONFILE="C:\SQL2019\Configuration2.ini"

./SQLAutoInstall.ps1 -InstanceName 'PROSQLADMIN1' -SQLServiceAccount
'MyDomain\SQLServiceAccount1' -SQLServiceAccountPassword
'Pa$$w0rd' -AgentServiceAccount 'MyDomain\SQLServiceAccount1'
-AgentServiceAccountPassword 'Pa$$w0rd'

param(
[string] $InstanceName,
[string] $SQLServiceAccount,
[string] $SQLServiceAccountPassword,
[string] $AgentServiceAccount,
[string] $AgentServiceAccountPassword
)
# Initialize ConnectionString variable
$ServerName = $env:computername
$ConnectionString = $ServerName + '\' + $InstanceName
#Install the instance
./SETUP.EXE /INSTANCENAME=$InstanceName
/SQLSVCACCOUNT=$SQLServiceAccount
/SQLSVCPASSWORD=$SQLServiceAccountPassword
/AGTSVCACCOUNT=$AgentServiceAccount
/AGTSVCPASSWORD=$AgentServiceAccountPassword
/CONFIGURATIONFILE="C:\SQL2019\Configuration2.ini"
# Configure OS settings
powercfg -setactive 8c5e7fda-e8bf-4a96-9a85-a6e23a8c635c
Set-ItemProperty -path HKLM:\SYSTEM\CurrentControlSet\ControlPriorityControl -name Win32PrioritySeparation -Type DWORD -Value 24
# Run smoke tests
Get-service -displayname *$InstanceName*
Invoke-sqlcmd -Serverinstance $ConnectionString -Query "SELECT @@SERVERNAME"

param(
[Parameter(Mandatory=$true)]
[string] $InstanceName,
[Parameter(Mandatory=$true)]
[string] $SQLServiceAccount,
[Parameter(Mandatory=$true)]
[string] $SQLServiceAccountPassword,
[Parameter(Mandatory=$true)]

[string] $AgentServiceAccount,
[Parameter(Mandatory=$true)]
[string] $AgentServiceAccountPassword
)
# Initialize ConnectionString variable
$ServerName = $env:computername
$ConnectionString = $ServerName + '\' + $InstanceName
"Initialize variables complete..."
#Install the instance
./SETUP.EXE /INSTANCENAME=$InstanceName
/SQLSVCACCOUNT=$SQLServiceAccount
/SQLSVCPASSWORD=$SQLServiceAccountPassword
/AGTSVCACCOUNT=$AgentServiceAccount
/AGTSVCPASSWORD=$AgentServiceAccountPassword
/CONFIGURATIONFILE="C:\SQL2019\Configuration2.ini"
"Instance installation complete..."
# Configure OS settings
powercfg -setactive 8c5e7fda-e8bf-4a96-9a85-a6e23a8c635c
"High Performance power plan configured..."
Set-ItemProperty -path HKLM:\SYSTEM\CurrentControlSet\ControlPriorityControl -name Win32PrioritySeparation -Type DWORD -Value 24
"Optimize for background services configured..."
# Run smoke tests
Get-service -displayname *$InstanceName* -ErrorAction Stop
"Service running check complete..."
Invoke-sqlcmd -Serverinstance $ConnectionString -Query "SELECT @@SERVERNAME"
"Instance accessibility check complete..."

; Specifies a Windows collation or an SQL collation to use for the Database
; Engine.
SQLCOLLATION="Latin1_General_CI_AS"
; Account for SQL Server service: Domain\User or system account.
SQLSVCACCOUNT="MyDomain\SQLServiceAccount1"
; Password for the SQL Server service account.
SQLSVCPASSWORD="Pa$$w0rd"
; Windows account(s) to provision as SQL Server system administrators.
SQLSYSADMINACCOUNTS="MyDomain\SQLDBA"
; Specify 0 to disable or 1 to enable the TCP/IP protocol.
TCPENABLED="1"
; Specify 0 to disable or 1 to enable the Named Pipes protocol.
NPENABLED="1"
Tip  If you use a configuration file created by a previous SQL Server installation
as a template for your own config file, you will notice that the following
parameters are specified: MATRIXCMBRICKCOMMPORT, MATRIXCMSERVERNAME,
MATRIXNAME, COMMFABRICENCRYPTION, COMMFABRICNETWORKLEVEL, and
COMMFABRICPORT. These parameters are intended for internal use by Microsoft
only and should be ignored. They have no effect on the build.
Assuming that this configuration file had been saved as c:\SQL2019\configuration1.ini,
then the code in Listing 3-8 could be used to run setup.exe from PowerShell.
Listing 3-8.  Installing SQL Server Using a Configuration File
.\setup.exe /CONFIGURATIONFILE="c:\SQL2019\Configuration1.ini"
Chapter 3  Server Core Installation

SQLCOLLATION="Latin1_General_CI_AS"
; Windows account(s) to provision as SQL Server system administrators.
SQLSYSADMINACCOUNTS="MyDomain\SQLDBA"
; Specify 0 to disable or 1 to enable the TCP/IP protocol.
TCPENABLED="1"
; Specify 0 to disable or 1 to enable the Named Pipes protocol.
NPENABLED="1"
This means that to successfully install the instance, you will need to use a mix of
parameters from the configuration file and also inline with the command that runs
setup.exe, as demonstrated in Listing 3-10. This example assumes that the configuration
in Listing 3-9 has been saved as C:\SQL2019\Configuration2.ini and will install an
instance named PROSQLADMINCONF2.
Listing 3-10.  Installing SQL Server Using a Mix of Parameters and a
Configuration File
.\SETUP.EXE /INSTANCENAME="PROSQLADMINCONF2"
/SQLSVCACCOUNT="MyDomain\SQLServiceAccount1"
/SQLSVCPASSWORD="Pa$$w0rd"
/AGTSVCACCOUNT="MyDomain\SQLServiceAccount1"
/AGTSVCPASSWORD="Pa$$w0rd"
/CONFIGURATIONFILE="C:\SQL2019\Configuration2.ini"
Automatic Installation Routines
This approach gives us the benefit of having a consistent configuration file that we do
not need to modify every time we build out a new instance. This idea can be taken even
further, however. If we were to save our PowerShell command as a PowerShell script,
then we could run the script and pass in parameters, rather than rewrite the command
each time. This will give a consistent script for building new instances, which we can
place under change control. The code in Listing 3-11 demonstrates how to construct a
parameterized PowerShell script, which will use the same configuration file. The script
assumes D:\ is the root folder of the installation media.
Chapter 3  Server Core Installation