displaying SQL server list

[Piotrek Stachowicz]

Hi,
I'd like to display list of all MS SQL servers which are available on
the network
(I write application which uses database located on one of the machines in
my LAN). Has anyone got any idea what to do in order to obtain list of all
such servers?!

When you open Sql Service Manager (for sql server2000) you've got such list.

Thanks,

Piotrek

[Chua Wen Ching]

Hi Piotrei Stachowicz,

You can use enumeration. There is a good example, i somehow extract it.

public enum ServerType : uint
{
/// <summary>
/// All workstations
/// </summary>
SV_TYPE_WORKSTA TION = 0x00000001,
/// <summary>
/// All computers that have the server service running
/// </summary>
SV_TYPE_SERVER = 0x00000002,
/// <summary>
/// Any server running Microsoft SQL Server
/// </summary>
SV_TYPE_SQLSERV ER = 0x00000004,
/// <summary>
/// Primary domain controller
/// </summary>
SV_TYPE_DOMAIN_ CTRL = 0x00000008,
/// <summary>
/// Backup domain controller
/// </summary>
SV_TYPE_DOMAIN_ BAKCTRL = 0x00000010,
/// <summary>
/// Server running the Timesource service
/// </summary>
SV_TYPE_TIME_SO URCE = 0x00000020,
/// <summary>
/// Apple File Protocol servers
/// </summary>
SV_TYPE_AFP = 0x00000040,
/// <summary>
/// Novell servers
/// </summary>
SV_TYPE_NOVELL = 0x00000080,
/// <summary>
/// LAN Manager 2.x domain member
/// </summary>
SV_TYPE_DOMAIN_ MEMBER = 0x00000100,
/// <summary>
/// Server sharing print queue
/// </summary>
SV_TYPE_PRINTQ_ SERVER = 0x00000200,
/// <summary>
/// Server running dial-in service
/// </summary>
SV_TYPE_DIALIN_ SERVER = 0x00000400,
/// <summary>
/// Xenix server
/// </summary>
SV_TYPE_XENIX_S ERVER = 0x00000800,
/// <summary>
/// Windows NT workstation or server
/// </summary>
SV_TYPE_NT = 0x00001000,
/// <summary>
/// Server running Windows for Workgroups
/// </summary>
SV_TYPE_WFW = 0x00002000,
/// <summary>
/// Microsoft File and Print for NetWare
/// </summary>
SV_TYPE_SERVER_ MFPN = 0x00004000,
/// <summary>
/// Server that is not a domain controller
/// </summary>
SV_TYPE_SERVER_ NT = 0x00008000,
/// <summary>
/// Server that can run the browser service
/// </summary>
SV_TYPE_POTENTI AL_BROWSER = 0x00010000,
/// <summary>
/// Server running a browser service as backup
/// </summary>
SV_TYPE_BACKUP_ BROWSER = 0x00020000,
/// <summary>
/// Server running the master browser service
/// </summary>
SV_TYPE_MASTER_ BROWSER = 0x00040000,
/// <summary>
/// Server running the domain master browser
/// </summary>
SV_TYPE_DOMAIN_ MASTER = 0x00080000,
/// <summary>
/// Windows 95 or later
/// </summary>
SV_TYPE_WINDOWS = 0x00400000,
/// <summary>
/// Root of a DFS tree
/// </summary>
SV_TYPE_DFS = 0x00800000,
/// <summary>
/// Terminal Server
/// </summary>
SV_TYPE_TERMINA LSERVER = 0x02000000,
/// <summary>
/// Server clusters available in the domain
/// </summary>
SV_TYPE_CLUSTER _NT = 0x01000000,
/// <summary>
/// Cluster virtual servers available in the domain
/// (Not supported for Windows 2000/NT)
/// </summary>
SV_TYPE_CLUSTER _VS_NT = 0x04000000,
/// <summary>
/// IBM DSS (Directory and Security Services) or equivalent
/// </summary>
SV_TYPE_DCE = 0x10000000,
/// <summary>
/// Return list for alternate transport
/// </summary>
SV_TYPE_ALTERNA TE_XPORT = 0x20000000,
/// <summary>
/// Return local list only
/// </summary>
SV_TYPE_LOCAL_L IST_ONLY = 0x40000000,
/// <summary>
/// Lists available domains
/// </summary>
SV_TYPE_DOMAIN_ ENUM = 0x80000000
}

For more info how to implement it:
http://codeproject.com/csharp/CompPickerLib.asp

Hope it helps you.
--
Regards,
Chua Wen Ching :)
"Piotrek Stachowicz" wrote:

Hi,
I'd like to display list of all MS SQL servers which are available on
the network
(I write application which uses database located on one of the machines in
my LAN). Has anyone got any idea what to do in order to obtain list of all
such servers?!

When you open Sql Service Manager (for sql server2000) you've got such list.

Thanks,

Piotrek