EnumSQLSvr.exe - Enumerate SQL Servers

version: 1.0x002
last updated: 27 January 2003
platform: SQL Server 2000 running Windows NT 4.0 and higher

Description:

Enumerate SQL Servers in a domain using the LAN Manager API NetServerEnum().

See also: ListSQLSvr - Enumerate SQL Servers on the network using ODBC SQLBrowseConnect

Usage:

EnumSQLSvr.exe version 1.0x2

EnumSQLSvr usage:

-D Enumerate SQL Servers in specified domain (default is primary domain)
-X Extended info
-V Verbose mode
-? This help screen

sample usage:
EnumSQLSvr <CR>
Lists all SQL Server instances in primary domain
EnumSQLSvr -D MyDomain <CR>
Lists all SQL Server instances in domain: MyDomain

Sample output:

First example lists the SQL Servers in your current domain

EnumSQLSvr <CR>
ASTERIX
IDEFIX
OBELIX
Total entries fetched 3

Second example lists the SQL Servers in your current domain with extended information (if available)

EnumSQLSvr -X <CR>
name:c     ASTERIX
comment:   GertD@SQLDev.Net development machine
OS version 5.1
name:      IDEFIX
comment:
OS version 5.2
name:      OBELIX
comment:
OS version 5.0
Total entries fetched 3

Third example lists the SQL Servers in a specified domain with extended information (if available)

EnumSQLSvr -X -D SQLDEV <CR>
name:c     ASTERIX
comment:   GertD@SQLDev.Net development machine
OS version 5.1
name:      IDEFIX
comment:
OS version 5.2
name:      OBELIX
comment:
OS version 5.0
Total entries fetched 3

Installation:

Simply copy EnumSQLSvr.exe onto your machine.

Download EnumSQLSvr.zip

Download EnumSQLSvr-src.zip (Visual C++ 7.0 project)

Requirements:

Windows NT 4.0 or higher.

Planned functionality enhancements:

None
Other suggestions, ideas, please send email to ideas

***