Test connectivity to a local or remote SQL Server database using PowerShell

test-sql-server-connectivity

function Test-SqlConnection {
    param(
        [Parameter(Mandatory)]
        [string]$ConnectionString
    )

    $ErrorActionPreference = 'Stop'

    try {
        $sqlConnection = New-Object System.Data.SqlClient.SqlConnection $ConnectionString
        $sqlConnection.Open()
        ## This will run if the Open() method does not throw an exception
        $true
    } catch {
        $false
    } finally {
        ## Close the connection when we're done
        $sqlConnection.Close()
    }
}

Test-SqlConnection -ConnectionString 'Data Source=MyServer;Initial Catalog=MyDatabase;Integrated Security=true;Pooling=False;Connect Timeout=10;'