Test-SqlConnection.ps1

function Test-SqlConnection {
  param(
    [Parameter(Mandatory)]
    [string]$ServerName,
    [Parameter(Mandatory)]
    [string]$DatabaseName
  )

  $connectionString = "Data Source=$ServerName;Integrated Security=true;Initial Catalog=master;Connect Timeout=3;database=$DatabaseName;"
  $sqlConn = new-object ("Data.SqlClient.SqlConnection") $connectionString

  $sqlConn.Open()
  $sqlConn.GetSchema("Tables");

  if ($sqlConn.State -eq ‘Open’) {
    $sqlConn.Close();
    "Opened successfully."
  }
}