471,078 Members | 816 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,078 software developers and data experts.

displaying SQL server list

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
Nov 16 '05 #1
1 2311
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_WORKSTATION = 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_SQLSERVER = 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_SOURCE = 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_SERVER = 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_POTENTIAL_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_TERMINALSERVER = 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_ALTERNATE_XPORT = 0x20000000,
/// <summary>
/// Return local list only
/// </summary>
SV_TYPE_LOCAL_LIST_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

Nov 16 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Yoshitha | last post: by
3 posts views Thread by GeekyChicky79 | last post: by
8 posts views Thread by Greg Lyles | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.