Install Microsoft SQL Server 2016 unattended

sql_2016_unattended.ps1

$serviceAccount = "";
$serviceAccountPassword = "";
$key = "";
$instanceName = "MSSQLSERVER";
$sqlRootDir = "";
$setupPath = [System.IO.Path]::Combine($installLocation, "SQL2016", "Setup.exe");

$argumentList = `
  "/Q " +`
  "/ACTION=`"Install`" " +`
  "/PID=`"$key`" "+ `
  "/FEATURES=`"SQL,AS,RS,IS`" "+ `
  "/UpdateEnabled=`"False`" "+ `
  "/INDICATEPROGRESS "+ `
  "/IAcceptSQLServerLicenseTerms "+ `
  "/IACCEPTROPENLICENSETERMS " + `
  "/INSTANCENAME=`"$instanceName`" "+ `
  "/ERRORREPORTING=`"False`" "+
  "/TCPENABLED=`"1`" " +`
  "/NPENABLED=`"0`" "+`
  "/AGTSVCACCOUNT=`"$serviceAccount`" " +`
  "/AGTSVCPASSWORD=`"$serviceAccountPassword`" " +`
  "/AGTSVCSTARTUPTYPE=`"Automatic`" " +`
  "/ASSVCACCOUNT=`"$serviceAccount`" " +`
  "/ASSVCPASSWORD=`"$serviceAccountPassword`" " +`
  "/ASSYSADMINACCOUNTS=`"BUILTIN\Administrators`" " +
  "/ASSVCSTARTUPTYPE=`"Automatic`" " +`
  "/ASDATADIR=`"$sqlRootDir\OLAP\Data`" " +`
  "/ASLOGDIR=`"$sqlRootDir\OLAP\Logs`" " +`
  "/ASBACKUPDIR=`"$sqlRootDir\Backup`" " +`
  "/ASTEMPDIR=`"$sqlRootDir\OLAP\Temp`" " +`
  "/ASCONFIGDIR=`"$sqlRootDir\OLAP\Config`" " +`
  "/SQLBACKUPDIR=`"$sqlRootDir\Backup`" " +`
  "/SQLSVCACCOUNT=`"$serviceAccount`" " +`
  "/SQLSVCPASSWORD=`"$serviceAccountPassword`" " +`
  "/SQLSYSADMINACCOUNTS=`"BUILTIN\Administrators`" " +`
  "/SQLSVCSTARTUPTYPE=`"Automatic`" " +`
  "/SQLTEMPDBDIR=`"$sqlRootDir\MsSql\Temp`" " +`
  "/SQLTEMPDBLOGDIR=`"$sqlRootDir\MsSql\Temp`" " +`
  "/SQLUSERDBDIR=`"$sqlRootDir\MsSql\Data`" " +`
  "/SQLUSERDBLOGDIR=`"$sqlRootDir\MsSql\Data`" " +`
  "/FILESTREAMLEVEL=`"3`"  " +`
  "/FILESTREAMSHARENAME=`"MSSQLSERVER`" " +`
  "/BROWSERSVCSTARTUPTYPE=`"Automatic`" " +`
  "/RSINSTALLMODE=`"DefaultNativeMode`" " +`
  "/RSSVCACCOUNT=`"$serviceAccount`" " +`
  "/RSSVCPASSWORD=`"$serviceAccountPassword`" " +`
  "/RSSVCSTARTUPTYPE=`"Automatic`" " + `
  "/ISSVCACCOUNT=`"$serviceAccount`" " +`
  "/ISSVCPASSWORD=`"$serviceAccountPassword`" " +`
  "/ISSVCStartupType=`"Automatic`" " + `
  "/SQLCOLLATION=`"Latin1_General_CI_AS`"";

Write-Host "$setupPath $argumentList"
$process = Start-Process $setupPath -ArgumentList $argumentList -PassThru -NoNewWindow -Wait -RedirectStandardOutput $pwd\sql_stdout.txt -RedirectStandardError $pwd\sql_stderr.txt