I am provisioning some softwares through PowerShell script to install and create a final packer image on azure. On SQL server installation step it throws an error.
==> myVM: Provisioning with Powershell...
==> myVM: Provisioning with powershell script: ./MyPowerShellScript.ps1
myVM:
myVM: Success Restart Needed Exit Code Feature Result
myVM: ------- -------------- --------- --------------
myVM: True No Success {ASP.NET 4.6, .NET Framework 3.5 (includes...
myVM:
myVM: cfg : http://schemas.microsoft.com/wbem/wsman/1/config/service/auth
myVM: lang : en-US
myVM: Basic : false
myVM: Kerberos : true
myVM: Negotiate : true
myVM: Certificate : false
myVM: CredSSP : true
myVM: CbtHardeningLevel : Relaxed
myVM:
myVM:
myVM: PsExec v2.33 - Execute processes remotely
myVM: Copyright (C) 2001-2021 Mark Russinovich
myVM: Sysinternals - www.sysinternals.com
myVM:
myVM: .\SETUP.EXE exited with error code -2068774911.
==> myVM: Script exited with non-zero exit status: 2226192385.Allowed exit codes are: [0]
==> myVM: Step "StepProvision" failed
main.json provisioner section:
}],
"provisioners": [{
"type": "powershell",
"script": "./MyPowerShellScript.ps1"
}]
}
MyPowerShellScript.ps1
Install-WindowsFeature -Name Web-Server -IncludeAllSubFeature
$webClient = New-Object System.Net.WebClient
$webURL = "http://package-URL/SQLEXPRADV.zip"
$filePath = ".\SQLEXPRADV.zip"
$Webclient.DownloadFile($webURL, $filePath)
Start-Sleep -s 120
Expand-Archive -LiteralPath SQLEXPRADV.zip -DestinationPath .
Start-Sleep -s 120
cd SQLEXPRADV;
Enable-WSManCredSSP -Role Server -Force
Set-Item -Path "WSMan:\localhost\Service\Auth\CredSSP" -Value $true
.\PsExec.exe /accepteula .\SETUP.EXE /Q /IAcceptSQLServerLicenseTerms /ACTION=install /UpdateEnabled=False /FEATURES=SQL /INSTANCENAME=SQL14 /SQLSVCACCOUNT='NT Authority\System' /SQLSYSADMINACCOUNTS='.\administrator' /AGTSVCACCOUNT='NT Authority\System' /SECURITYMODE=SQL /SAPWD='PaXXXXXXXX' /SQLTEMPDBDIR='C:\MSSQL\TempDB\\' /SQLUSERDBDIR='C:\MSSQL\Data\\' /SQLUSERDBLOGDIR='C:\MSSQL\Log\\'