How do I get a list of sql servers running on network?

[Jeff Pipes]

I want to be able to get a list of all sql servers running on the network.
I know this is possible because when you add a new registration in enterprise
manager, you can click on a button and it will will pop up a dialog with
all the sql servers it can find. I want to be able to do the same thing.

-Jeff

[Phil Weber]

> I want to be able to get a list of all sql servers running
> on the network.

Jeff: http://www.vbcity.com/forums/topic.asp?tid=5537
---
Phil Weber

[Jeff Pipes]

You da man! thanks

-Jeff

"Phil Weber" <pweber@nospam.fawcette.com> wrote:
> > I want to be able to get a list of all sql servers running
> > on the network.
>
>Jeff: http://www.vbcity.com/forums/topic.asp?tid=5537
>---
>Phil Weber
>
>

[Jeff Pipes]

I prefer to use the api since I don't have to distribute an extra library
with my app and I can't rely on using active directory. However the api code
listed on that site has a few problems. First it only returns the name of
the machine that is running sql server, not the actual name of the sql server.
As I understand it, these two do not have to be the same. Second, if a machine
is running multiple instances of sql server, it only sees one instance. Third,
when I run the code on windows 98, I get a 'can't find dll entry point netserverenum
in netapi32.dll' error.

-Jeff

"Phil Weber" <pweber@nospam.fawcette.com> wrote:
> > I want to be able to get a list of all sql servers running
> > on the network.
>
>Jeff: http://www.vbcity.com/forums/topic.asp?tid=5537
>---
>Phil Weber
>
>

[Phil Weber]

> the api code listed on that site has a few problems.

Jeff: Try searching for "netserverenum sql server" (and, optionally, "vb.net
netserverenum" or "c# netserverenum" or "netserverenum windows 98") at
http://www.google.com and/or http://groups.google.com .
---
Phil Weber