Thanks for the insight Dave. I was thinking, to be able to access any data off a remote server without a datasource specifically set up for it, it would have to be a linked server to the one I was using anyway.
I might as well just use select * from sys.servers Hmmm-- Oh well, I just wanted to see if it was possible anyway. ~Brad -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 6:01 PM To: CF-Talk Subject: RE: get a list of database servers on network > 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:278659 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
