SQL 2017 Installation stuck at Install_VSTA2015

SQL 2017 Installation stuck at "Install_VSTA2015_LangSupport_Cpu32_Action"

 

Log file (C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log):

 

Fix:

Run the below command from PowerShell, so the msiserver service will restart automatically

taskkill /F /FI "SERVICES eq msiserver"

PowerShell script to extract Windows Application Pool details

 $sb = {  Import-Module WebAdministration

         $webapps = Get-WebApplication

$list = @()

foreach ($webapp in get-childitem IIS:\AppPools\)

{

$name = "IIS:\AppPools\" + $webapp.name

$item = @{}

$item.server = $env:COMPUTERNAME

$item.WebAppName = $webapp.name

$item.Version = (Get-ItemProperty $name managedRuntimeVersion).Value

$item.State = (Get-WebAppPoolState -Name $webapp.name).Value

$item.UserIdentityType = $webapp.processModel.identityType

$item.Username = $webapp.processModel.userName

$obj = New-Object PSObject -Property $item

$list += $obj

}

$list | Select-object -Property  "server","WebAppName", "Version", "State", "UserIdentityType", "Username" 

}

$computers = Get-Content "C:\serverlist.txt"

foreach ($computer in $computers)  {

$computer

Invoke-command -ComputerName $computer -ScriptBlock $sb | export-csv C:\webAppPool_details.csv -append -NoTypeInformation

}