InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 04:01:09 GMT20http://www.sqlservercentral.com/Forums/Topic515342-146-1.aspxHiCode to do this in VB. (I think this came from a help file somewhere)Function FindServers() As DataTable Dim instance As System.Data.Sql.SqlDataSourceEnumerator = System.Data.Sql.SqlDataSourceEnumerator.Instance Dim dataTable As System.Data.DataTable = instance.GetDataSources() Return dataTable End FunctionHTHpgThu, 08 Sep 2011 04:30:37 GMTpg53http://www.sqlservercentral.com/Forums/Topic515342-146-1.aspxHi Brian Kelley, Thank you so much for your reply! Just Y'day i got this site through googling... and found that application is really usefull... Anyways thank you so much for your help!!! :)Fri, 13 Jun 2008 01:00:07 GMTSakthivel Chidambaramhttp://www.sqlservercentral.com/Forums/Topic515342-146-1.aspxYou want to use SQLPing. Have a domain admin run it.[url=http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx]SQLSecurity.com Free Tools[/url]The registry option only works if you know to connect to the SQL Server. SQLPing will use all known means of identifying SQL Servers, including those which are uninstalled but not running at the time.Thu, 12 Jun 2008 11:34:57 GMTK. Brian Kelleyhttp://www.sqlservercentral.com/Forums/Topic515342-146-1.aspxdone this already, use xp_regread to read the values from the registry and outputThu, 12 Jun 2008 11:32:18 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic515342-146-1.aspxOr is there any T-SQL Query to find on which port a particular instance is running? I checked in sysrpocessed for one SPID it shows which protocol it has used to connect (TCP/IP or Named..) but it does not show which is the port used...Thu, 12 Jun 2008 08:50:55 GMTSakthivel Chidambaramhttp://www.sqlservercentral.com/Forums/Topic515342-146-1.aspxHi, We have a requirement. One of our application called Discoverer will scan through the network and list the inventory of SQL Servers. But the problem is it has only option to enter the port for scanning and no option to type instance. so if we give port as 1433 and scan the network, it misses the servers which don't have 1) Default Instance. 2) Dynamic Port is used. 3) If Instance/Server is listening in different port. Can someone guide me on this please? Any idea to discover the list of instance and which port they listen when we specify the hostname or just specify the IP Range..? :hehe:Wed, 11 Jun 2008 10:19:10 GMTSakthivel Chidambaram