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?How is the list derived is easy (http://support.microsoft.com/default.aspx?scid=kb;en-us;287737). How can the list be managed gets really complicated! What are you looking to acheive in the way of "managing" the list?
-PatP|||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.|||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")?|||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.
