December 18, 2009 at 12:26 pm
Hello all,
When I select the <Browse for more...> option in the SSMS Connect to Server dialog, several of the servers that I can manually key into the Server name and connect to are not visible in the browse list. Can anyone tell me why this is? Thanks in advance for any ideas and/or suggestions!
December 19, 2009 at 12:16 am
One of the reasons could be that the instance is hidden?
Configuration manager -> SS2K5 Network config ->Protocols for <<instance>> -> properties -> Hide instance?
---------------------------------------------------------------------------------
December 21, 2009 at 10:39 am
There are lots of reasons, but in my experience, there are two (or three) biggies...
First is what nabha already mentioned: some instances are hidden and won't ever show up.
Second, is that the network browsing technique that is being used just seems to be unreliable. As there's no central registry to query for all SQL Servers (AFAIK), I think that the "Browse..." option just watches the network traffic for several seconds to see if any SQL Server traffic goes by and pulls the instance names from that. If an instance does not happen to have any network activity during this time, then it won't show up.
The third is that in larger enterprise networks, this Browsing collector can definitely get overwhelmed and lose instances.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply