Get All Installed SQL Server Instances On Local Machine Using C#

In this blog, I have explained how to list the installed instances of SQL Server on machine and LAN Network using C#.

This is a very short code snippet where I will explain how to list the SQL Server instances that are installed on your machine and on the network connected to your machine. By using SqlDataSourceEnumerator and EnumAvailableSqlServers, we can get SQL Server instances that are installed on your machine as well as on the network, connected.

 

For this, we need to import these classes.

using System;
using System.Data;
using System.Data.Sql;
using Microsoft.Win32;
using Microsoft.SqlServer.Management.Smo;

Using SqlDataSourceEnumerator Class

 

The SqlDataSourceEnumerator class allows you to get the instances of the SQL Server installed on the machine and also on the network the machine is connected to.

private void GetDataSources()
{
    SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance;
    DataTable table = instance.GetDataSources();
    string ServerName = Environment.MachineName;
    foreach (DataRow row in table.Rows)
    {
        Console.WriteLine (ServerName + "\\" + row["InstanceName"].ToString());
    }
}

Using EnumAvailableSqlServers Class

 

First of all, you need to add a reference to the Microsoft.SqlServer.smo.dll file to your project which is available in NuGet Package Manager.

private void GetDataSources()
{
    DataTable table = SmoApplication.EnumAvailableSqlServers(true);
    string ServerName = Environment.MachineName;
    foreach (DataRow row in table.Rows)
    {
        Console.WriteLine(ServerName + "\\" + row["InstanceName"].ToString());
    }
}

EnumAvailableSqlServers and SqlDataSourceEnumerator will only find named instances if the SQL Server Browser services are running. If you want to get the SQL Server instance name on the current computer, you can read the information from the registry.

private void GetDataSources2()
{
    string ServerName = Environment.MachineName;
    RegistryView registryView = Environment.Is64BitOperatingSystem ? RegistryView.Registry64 : RegistryView.Registry32;
    using (RegistryKey hklm = RegistryKey.OpenBaseKey(RegistryHive.LocalMachine, registryView))
    {
        RegistryKey instanceKey = hklm.OpenSubKey(@"SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL", false);
        if (instanceKey != null)
        {
            foreach (var instanceName in instanceKey.GetValueNames())
            {
                Console.WriteLine(ServerName + "\\" + instanceName);
            }
        }
    }
}

These simple tips can help all readers. I hope you find this blog helpful.

 

Happy Coding!