Obtaining the list of all SQL server and instance on the network

• Ammad Baig

  Mr or Mrs. 500

  Points: 577

  More actions

  July 16, 2007 at 2:53 pm

  #196978

  Hello,

  Is there any way to retrieve the list of all the SQL Servers along with each instance from the network? I tried SQLPing utility and it only gives a list of the default instances since they're on default SQL Server port. Also the osql command with the -l option doesn't contain the entire list since it scans only the default port as well.

  Also, is there a way to retrieve a list of all the DBs in the instance?

  Thank you.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738663

  More actions

  July 16, 2007 at 4:12 pm

  #719822

  There are a few threads on this, but there isn't necessarily a great way. The network has to allow scans on the UDP port and some block it.

  There are some third party utilities that can help. I've always scanned services as the most accurate way.

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=54&messageid=18366

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=247083

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=374262

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  July 16, 2007 at 10:33 pm

  #719859

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=374262

  This mssage post should help you the script is given there in th post chain itself.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com