Powershell test connection to sql server

testconnection.ps1

$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = "Data Source=mssqlprod01;Initial Catalog=master;User Id=youruser;Password=yourpassword" 
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.CommandText = 'SELECT @@SERVERNAME AS ServerName'
$SqlCmd.Connection = $SqlConnection 
$SqlConnection.Open()
$rdr = $SqlCmd.ExecuteReader()
while($rdr.Read())
{
  $rdr["ServerName"].ToString()
}
$SqlConnection.Close()