C# .NET - Get SQL Servers list

How to get the registered Sql Servers list of Sql server Management studio in windows application using C#

hi,

Here code for registered servers in C#

using System;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Smo.RegisteredServers;

namespace SMOTest
{
    class Program
    {
      static void Main()
      {
       RegisteredServer[] rsvrs = SmoApplication.SqlServerRegistrations.EnumRegisteredServers();
       String localserver = System.Environment.MachineName;
	   
       foreach (RegisteredServer rs in rsvrs)
       {
         Console.WriteLine(rs.ServerInstance.Replace(".",localserver)
                                            .Replace("(local)",localserver)
                                            .Replace("localhost",localserver));
       }
      }
    }
}

read more:http://www.sqldbatips.com/showarticle.asp?ID=45

Regards,

Enumerating Registered Servers

To enumerate servers registered in SQL Server Management Studio we can use the EnumRegisteredServers method of the SqlServerRegistrations class. One vast improvment over SQL-DMO is that there is no longer any need to use recursion to loop through the servers and server groups.

[Visual Basic]

Imports Microsoft.SqlServer.Management.Smo.RegisteredServers
Imports Microsoft.SqlServer.Management.Smo

Module SMOTest

   Sub Main()
    Dim rsvrs as RegisteredServer() = SmoApplication.SqlServerRegistrations.EnumRegisteredServers()
      Dim localserver As String = System.Environment.MachineName
    For Each rs As RegisteredServer in rsvrs

     Console.WriteLine(rs.ServerInstance.Replace(".",localserver) _
                        .Replace("(local)",localserver) _
                        .Replace("localhost",localserver))

    Next
   End Sub

End Module

[C#]

using System;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Smo.RegisteredServers;

namespace SMOTest
{
    class Program
    {
    static void Main()
    {
     RegisteredServer[] rsvrs = SmoApplication.SqlServerRegistrations.EnumRegisteredServers();
     String localserver = System.Environment.MachineName;
       
     foreach (RegisteredServer rs in rsvrs)
     {
     Console.WriteLine(rs.ServerInstance.Replace(".",localserver)
                        .Replace("(local)",localserver)
                        .Replace("localhost",localserver));
     }
    }
    }
}

Sorry, I want to bind them to a drop down list, can you tell me the code in windows and not in console application

Yes you can easily get sql server infor using SMO, so you can do this in your window form only need to include these namespace on your from as

using System;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Smo.RegisteredServers;

and then you need to get that list in your code and bind it with dropdwonlist as follows

       RegisteredServer[] rsvrs = SmoApplication.SqlServerRegistrations.EnumRegisteredServers();
       String localserver = System.Environment.MachineName;
	   
       foreach (RegisteredServer rs in rsvrs)
       {
	dd1SqlServer.Add(rs.ServerInstance.Replace(".",localserver)
                                            .Replace("(local)",localserver)
                                            .Replace("localhost",localserver)  );
       }
     

Hi..

check here previous post of Eggheadcafe ..

http://www.eggheadcafe.com/community/csharp/2/10116078/find-sql-servers-on-local-system.aspx

Hi,

You can use this code

Windows/ASP.NET web Applications

and Add Referance of  Microsoft.SqlServer.Smo from AddReference window.

and using