以编程方式查找SQL Server的所有实例

好，所以我解决了这个问题.我所做的是几件事:

Ok so I resolved the issue. What I have done is a few things:

• 首先，我在域中扫描计算机.
• 检查SQLBrowser服务是否正在运行，如果没有运行，请启动它！这是由位于 system.ServiceProcess
中的 ServiceController类完成的
• 启动所有SQLBrowser之后，我使用 SqlDataSourceEnumerator 枚举所有实例.

• First I scan the domain for machines.
• Check if the SQLBrowser service is running, if not, start it! which is done by the ServiceController class located in system.ServiceProcess
• After all the SQLBrowser have been started I use the SqlDataSourceEnumerator to enumerate through all the instances.

对于那些对代码感兴趣的人:
注意:您需要网络管理员权限才能在远程计算机上启动它.

For those interested in the code:
Note: you need network admin rights to start it on the remote machines.

public void StartSqlBrowserService(List<String> activeMachines)
{
    ServiceController myService = new ServiceController();
    myService.ServiceName = "SQLBrowser";

    foreach (var machine in activeMachines)
    {
        try
        {
            myService.MachineName = machine;
            string svcStatus = myService.Status.ToString();
            switch (svcStatus)
            {
                case "ContinuePending":
                    Console.WriteLine("Service is attempting to continue.");
                    break;

                case "Paused":
                    Console.WriteLine("Service is paused.");
                    Console.WriteLine("Attempting to continue the service.");
                    myService.Continue();
                    break;

                case "PausePending":
                    Console.WriteLine("Service is pausing.");
                    Thread.Sleep(5000);
                    try
                    {
                        Console.WriteLine("Attempting to continue the service.");
                        myService.Start();
                    }
                    catch (Exception e)
                    {
                        Console.WriteLine(e.Message);
                    }
                    break;

                case "Running":
                    Console.WriteLine("Service is already running.");
                    break;

                case "StartPending":
                    Console.WriteLine("Service is starting.");
                    break;

                case "Stopped":
                    Console.WriteLine("Service is stopped.");
                    Console.WriteLine("Attempting to start service.");
                    myService.Start();
                    break;

                case "StopPending":
                    Console.WriteLine("Service is stopping.");
                    Thread.Sleep(5000);
                    try
                    {
                        Console.WriteLine("Attempting to restart service.");
                        myService.Start();
                    }
                    catch (Exception e)
                    {
                        Console.WriteLine(e.Message);
                    }
                    break;
            }
        }
        catch (Exception e)
        {
            Console.WriteLine(e.Message);
        }
    }
}

然后这就是我用来检索实例的东西.

And then this is what I use to retrieve the instances.

public static void SqlTestInfo()
{
    SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance;
    DataTable table = instance.GetDataSources();
    DisplayData(table);
}

private static void DisplayData(DataTable table)
{
    foreach (DataRow row in table.Rows)
    {
        foreach (DataColumn dataColumn in table.Columns)
        {
            Console.WriteLine("{0} = {1}", dataColumn.ColumnName, row[dataColumn]);
        }
        Console.WriteLine();
    }
}

这可能不是最佳解决方案，有些人可能觉得它有些脏.但是目前，这是我能得到的最好的解决方法.
希望这可以帮助将来有同样问题的任何人.

It may not be the best solution, some may find it somewhat dirty. But for now it's the best workaround I could get.
Hope this helps any people in the future having the same problem.