Saturday, June 14, 2014

How to get list of available SQL Servers instances using C#

/// <summary>
/// Get SQL Server Instances if possible
/// </summary>
private static string[] GetSQLServerInstances()
{
    List<string> instances = new List<string>();
    try
    {
        System.Data.Sql.SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance;
        System.Data.DataTable table = instance.GetDataSources();
 
        foreach (System.Data.DataRow row in table.Rows)
        {
            instances.Add(row[0] + "\\" + row[1]);
        }
    }
    catch (Exception)
    {
 
    }
    return instances.ToArray();
}

No comments:

Post a Comment