public bool IsConnectionValid()
 {
     string connectionString = String.Format("Data source= {0}; Initial catalog= {1}; UID= {2}; Password= {3};",
        ServerName, DatabaseName, LoginDB, PasswordDB);
     var connection = new SqlConnection(connectionString);
     try
     {
         connection.QuickOpen(SqlConnectionConstants.OpenTimeout);
         connection.Close();
         return true;
     }
     catch (Exception e)
     {
         return false;
     }
 }
 public bool TestIps()
 {
     connectionStringBuilder.DataSource = this.Ip1;
     try
     {
         using (var conn = new SqlConnection(connectionStringBuilder.ToString()))
         {
             conn.QuickOpen(1000);
             return true;
         }
     }
     catch
     {
         connectionStringBuilder.DataSource = this.Ip2;
         try
         {
             using (var conn = new SqlConnection(connectionStringBuilder.ToString()))
             {
                 conn.QuickOpen(1000);
                 return true;
             }
         }
         catch
         {
             return false;
         }
     }
 }