gistfile1.txt

$connectionString = "Server= $SQLServer, $PORT;Database=$SQLDBName;User ID= $Username; Password= $Password;"

$conn = New-Object System.Data.SqlClient.SqlConnection
$conn.ConnectionString = $connectionString
$cmd = New-Object System.Data.SqlClient.SqlCommand
$cmd.commandtext = $query
$conn.open()

if ($conn.Open() -eq $true)
{
    Write-Host "connection established..."
}

$cmd.connection = $conn

$queryResult = $cmd.ExecuteReader()
$conn.close()