C# – Test SQL Server Instance / Node Connectivity by SqlConnection

C# – Test SQL Server Instance / Node Connectivity by SqlConnection

   SQLConnection.cs
 
  using System;
  using System.Collections.Generic;
  using System.Linq;
  using System.Text;
  using System.Data.SqlClient;
 
  namespace NetworkMonitor
  {
    public class SQLConnection
    {
      private string HostName;
      private Notification notify;
      private Library lib;
 
      public SQLConnection(string HostName)
      {
        this.HostName = HostName;
        this.notify = new Notification();
 
        this.lib = new Library();
      }
 
      public bool ValidateSQLServerAlive(string InstanceName, string DBName, string UserName, string Passwd)
      {
        SqlConnection conn = null;
        string connstr = "Data Source=" + InstanceName + "; Initial Catalog=" + DBName + "; User id=" + UserName + "; Password=" + Passwd + ";";
 
        try
        {
          conn = new SqlConnection(connstr);
          conn.Open();
 
          conn.Close();
 
          return true;
        }catch(Exception ex){
 
          return false;
 
        }
      }
    }
  }