How to get list of available SQL Servers using C# Code?

Question

I have created a desktop application. On application launch I want to display the list of all available SQL Server instances on the local PC, and allow to choose a SQL Server name to connect with.

Is there anyway to get the list of all SQL Server instance names that are available on the local PC?

Thanks a lot.

possible duplicate of How to list available instances of SQL Servers using SMO in C#? — Remus Rusanu
– Remus Rusanu, Commented May 28, 2012 at 8:10

Uday Teja · Accepted Answer · 2019-07-10 10:02:00Z

19

string myServer = Environment.MachineName;

DataTable servers = SqlDataSourceEnumerator.Instance.GetDataSources();
for (int i = 0; i < servers.Rows.Count; i++)
{
    if (myServer == servers.Rows[i]["ServerName"].ToString()) ///// used to get the servers in the local machine////
     {
         if ((servers.Rows[i]["InstanceName"] as string) != null)
            CmbServerName.Items.Add(servers.Rows[i]["ServerName"] + "\\" + servers.Rows[i]["InstanceName"]);
         else
            CmbServerName.Items.Add(servers.Rows[i]["ServerName"].ToString());
      }
  }

edited Jul 10, 2019 at 10:02

Uday Teja

2631 gold badge3 silver badges16 bronze badges

answered May 28, 2012 at 8:11

Pranay Rana

177k37 gold badges244 silver badges267 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Jameel Over a year ago

Thank you very much, Mr.Pranay . It works 100%, but must modify the code of ** servers.Rows["ServerName"].ToString()** to ** servers.Rows[i]["ServerName"].ToString() **. However, that is what I want.

Inside Man Over a year ago

What is CmbServerName?

Gabriel Marius Popescu Over a year ago

@InsideMan, most likely CmbServerName is a Winform ComboBox. Why is that important?

Inside Man Over a year ago

@GabrielMariusPopescu the combo box is not important at all

Rashad Valliyengal · Accepted Answer · 2014-03-18 06:15:54Z

4

        //// Retrieve the enumerator instance, and then retrieve the data sources.
        SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance;
        DataTable dtDatabaseSources = instance.GetDataSources();

        //// Populate the data sources into DropDownList.            
        foreach (DataRow row in dtDatabaseSources.Rows)
            if (!string.IsNullOrWhiteSpace(row["InstanceName"].ToString()))
                Model.DatabaseDataSourceNameList.Add(new ExportWizardChooseDestinationModel
                {
                    DatabaseDataSourceListItem = row["ServerName"].ToString()
                        + "\\" + row["InstanceName"].ToString()
                });

answered Mar 18, 2014 at 6:15

Rashad Valliyengal

3,1621 gold badge27 silver badges41 bronze badges

Comments

Karthik · Accepted Answer · 2012-05-28 08:11:47Z

2

try

SqlDataSourceEnumerator.Instance.GetDataSources()

answered May 28, 2012 at 8:11

Karthik

2,3996 gold badges35 silver badges66 bronze badges

Collectives™ on Stack Overflow

How to get list of available SQL Servers using C# Code?

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related