Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Location
    Rochester, NY
    Posts
    135

    Unanswered: how is "available servers" list populated

    When registering a new SQL Server in EM using the wizard a window appears that is supposed to list available SQL Servers, however it does not.

    So, my question is:

    How is this list derived? and how can the list be managed?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    How is the list derived is easy. How can the list be managed gets really complicated! What are you looking to acheive in the way of "managing" the list?

    -PatP

  3. #3
    Join Date
    May 2003
    Location
    Rochester, NY
    Posts
    135
    Pat,
    If you can give me how it is populated I'll work through the part of being mangeable. I'm dealing with servers in several domains clients scattered accross the company. So an answer to the first question of how it is derived would much appreciated. Thanks.

  4. #4
    Join Date
    May 2003
    Location
    Rochester, NY
    Posts
    135
    Sorry Pat I missed your link the first time.

    OK, so this executable would list the available SQL Servers on the local network segment, does this mean it would not detect servers residing on other subnets (hence the use of "local")?

  5. #5
    Join Date
    Jan 2005
    Location
    TempDb
    Posts
    228
    It can't tell you about what it can't see. And it has to have a narrow view, thus local is relative but applicable.

    Do the math - if it tried to enumerate every server and you had an internet connection (I hear these are popular), you'd end up launching SQLEM first thing in the morning, taking coffee, water, and other types of breaks, eating lunch, playing in a cricket tournament, starting a family, experiencing a mid-life crisis, then retiring and returning to discover other servers were missed because they were added while it was enumerating.
    I love deadlines. I like the whooshing sound they make as they fly by. Douglas Adams

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •