> In my internal web app, is it possible to populate a dropdown > with a list of computers on the network running a SQL Server. > > Basically, like in SQL enterprise Manager, when you would go > to register a new database with the wizard it would "search" > somehow and give you a list of servers to choose from. > > How did that work? Would it just scan the subnet for hosts > with port 1433 open?
My understanding is that this is a bit more complicated. SQL Server has a discovery port, UDP/1434, and I think that's what is used to discover instances using TCP/IP (as opposed to Windows Networking). SQL Enterprise Manager, however, may also use DBNETLIB to discover servers listening on named pipes, which your application will not be able to do. Finally, TCP/1433 is the default port for a single default instance, but you can configure your SQL Server to listen on another port - and will have to if you're running multiple named instances: each of those requires its own port. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278657 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
