if ($Action -eq "Install") sc.exe create "MSSQL $$InstanceName" binPath= " "$BinPath " -s$InstanceName" start= auto New-Item -Path $RegPath -Force elseif ($Action -eq "Remove") net stop "MSSQL $$InstanceName" 2>$null sc.exe delete "MSSQL $$InstanceName" Remove-Item -Path $RegPath -Recurse -Force -ErrorAction SilentlyContinue Write-Host "Service removed from this machine."
For 95% of "portable" use cases (local development, demos, training), LocalDB is the correct answer. ms sql server express portable
Windows Authentication (if your user has permissions) or SQL Login. if ($Action -eq "Install") sc