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


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

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

  1. #1
    Jeff Pipes Guest

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


    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

  2. #2
    Phil Weber Guest

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

    > 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



  3. #3
    Jeff Pipes Guest

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


    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
    >
    >



  4. #4
    Jeff Pipes Guest

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


    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
    >
    >



  5. #5
    Phil Weber Guest

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

    > 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



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center