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; } } } } |