get a list of database servers on network
Here's a good Friday question. 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? Is that possible with ColdFusion? Note: I am not talking about ColdFusion data sources at all here. ~Brad ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278654 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: get a list of database servers on network
In CF natively? Not any way that I'm aware of, but there are a variety of other apps to use (or code) that can scan for hosts listening on a given port... On 5/18/07, Brad Wood [EMAIL PROTECTED] wrote: Here's a good Friday question. 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? Is that possible with ColdFusion? Note: I am not talking about ColdFusion data sources at all here. ~Brad ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278656 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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. 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
RE: get a list of database servers on network
Yeah, I was just messing around with nmap, which I use for port scanning from DOS. nmap 10.10.0.1-255 -p1433 -R -oX C:\port_scan.txt would output an XML file I could then parse with CF, but reliability would probably be suspect. ~Brad -Original Message- From: Ken Wexel [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 4:54 PM To: CF-Talk Subject: Re: get a list of database servers on network In CF natively? Not any way that I'm aware of, but there are a variety of other apps to use (or code) that can scan for hosts listening on a given port... On 5/18/07, Brad Wood [EMAIL PROTECTED] wrote: Here's a good Friday question. 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? Is that possible with ColdFusion? Note: I am not talking about ColdFusion data sources at all here. ~Brad ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278658 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: get a list of database servers on network
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
