how to get sql server instance name currently running programatically

Question

I was creating connection string for sql express database dynamically.I wanted to know how to get the name of the server instance running currently in the local machine,programatically using c#.

Kangkan · Accepted Answer · 2011-12-07 04:36:31Z

2

You can use the following code:

using System;
using Microsoft.Win32;

namespace TestConsoleApp
{
    class Program
    {
      static void Main()
      {
        RegistryKey rk = Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Microsoft\Microsoft SQL Server");
        String[] instances = (String[])rk.GetValue("InstalledInstances");
        if (instances.Length > 0)
        {
           foreach (String element in instances)
           {
              if (element == "MSSQLSERVER")
                 Console.WriteLine(System.Environment.MachineName);
              else
                 Console.WriteLine(System.Environment.MachineName + @"\" + element);
           }
        }
        Console.ReadKey();
      }
    }
}

Edit:

If you wish to get the instances that are in running state, please refer to this link: http://support.microsoft.com/kb/q287737/

edited Dec 7, 2011 at 4:36

answered Dec 7, 2011 at 4:08

Kangkan

15.6k11 gold badges79 silver badges116 bronze badges

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

3 Comments

vinay singri Over a year ago

but how will i know the currently running instance?

Kangkan Over a year ago

Do you mean, the one whose service is on running state?

vinay singri Over a year ago

ya true, the one on which service is on running state

Collectives™ on Stack Overflow

how to get sql server instance name currently running programatically

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related