public static bool IsValidConnectionString(string connectionString)
{
var valid = false;
var conn = new System.Data.SqlClient.SqlConnection();
try
{
conn.ConnectionString = connectionString;
conn.Open();
valid = true;
}
catch (Exception ex)
{
valid = false;
}
finally
{
conn.Close();
}
return valid;
}