[SQL Server] Start, Stop Services via PowerShell Script

[SQL Server] Start, Stop Services via PowerShell Script

A simple example.

$Computer = "[ComputerName]"
#$sess = New-PSSession -ComputerName $Computer -Credential $credentialObejct # with the credential
$sess = New-PSSession -ComputerName $Computer 
Enter-PSSession $sess # Entering a new remote session

$ChangeStatus = "Start" # When you want to start the service
#$ChangeStatus = "Stop" # When you want to stop the service

$SQLServices = @()
$SQLServices += 'MSSQL$SQL2016' # Default Instance: MSSQLSERVER
$SQLServices += 'SQLAgent$SQL2016' # Default Instance: SQLSERVERAGENT
$SQLServices += 'MSSQL$SQL2017'
$SQLServices += 'SQLAgent$SQL2017'
$SQLServices += 'MSSQL$SQL2019'
$SQLServices += 'SQLAgent$SQL2019'

# For each services
foreach($serviceName in $SQLServices)
{
    $service = Get-Service | Where-Object {$_.Name -eq $serviceName}

    if(($ChangeStatus -eq "Start") -and ($service.Status -eq "Stopped")) # Start Services
    {
        Write-Host "Starting Service: "$service.DisplayName
        $service.Start()
    }

    if(($ChangeStatus -eq "Stop") -and ($service.Status -eq "Running")) # Stop Services
    {
        Write-Host "Stopping Service: "$service.DisplayName
        $service.Stop()
    }
}

Exit-PSSession # Exit from the remote session
Remove-PSSession $sess # Remove the remote session

Starting Service:  SQL Server (SQL2016)
Starting Service:  SQL Server Agent (SQL2016)
Starting Service:  SQL Server (SQL2017)
Starting Service:  SQL Server Agent (SQL2017)
Starting Service:  SQL Server (SQL2019)
Starting Service:  SQL Server Agent (SQL2019)