SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 Other Topics
 Tools to Scan for SQL Servers
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 06/20/2007 :  17:05:25  Show Profile  Reply with Quote

Does anyone know of good tools for scanning the network for SQL Servers?

I have been using SQLPing 3.0 that I found at the link below, but it is GUI based, so it is hard to automate. It does do a good job of finding SQL Servers in an IP address range using about 8 different methods of discovery, and allows export of the information to an XML file. The drawback is that I have to scan 100+ IP address ranges manually.
http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx

I want to be able to find instances of SQL Server and insert the info into a table. I am trying to maintain a complete inventory of SQL Server instances on the network, whether I manage them or not.

When someone comes to me to say their server is all messed up, I want to be able to say that it isn’t one I manage. And, of course, I would like to make sure that I have backups, etc. setup for the ones I should be managing, or at least have access to them.

I would like to be able to schedule scans of IP address ranges to occur on a regular basis to be able to discover new instances as they come online. I would like the tool to be able to discover any version of SQL Server.

It would also be very nice if it was free.






CODO ERGO SUM

SwePeso
Patron Saint of Lost Yaks

Sweden
30213 Posts

Posted - 06/20/2007 :  17:12:46  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Does this help?
http://www.codeproject.com/useritems/listsqlservers.asp?df=100&forumid=3432&exp=0&select=130122

http://www.sqldbatips.com/showarticle.asp?ID=45


Peter Larsson
Helsingborg, Sweden

Edited by - SwePeso on 06/20/2007 17:15:59
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30213 Posts

Posted - 06/20/2007 :  17:21:55  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Dim dmoServer As SQLDMO.SQLServer
Dim dmoApp As SQLDMO.Application
Dim dmoNameList As SQLDMO.NameList
Dim i As Integer
Set dmoServer = New SQLDMO.SQLServer
Set dmoApp = dmoServer.Application
Set dmoNameList = dmoApp.ListAvailableSQLServers()

For i = 0 To dmoNameList.Count - 1
    Debug.Print dmoNameList(i)
Next i


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 06/20/2007 :  18:00:14  Show Profile  Reply with Quote
The SQL DMO documentation indicates that it scans the local area network, so I don't know what range of IP addresses it would actually go after.

I need to be able to discover servers on a WAN, so I am not sure that would do the job for me. Also, I don't know if it could detect servers that are only installed, but not currently active.



CODO ERGO SUM

Edited by - Michael Valentine Jones on 06/21/2007 08:48:46
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 06/20/2007 :  18:58:35  Show Profile  Visit jezemine's Homepage  Reply with Quote
as I recall the SMO method depends on SQL Browser running on each remote, so it's not guaranteed to find all of them.


elsasoft.org
Go to Top of Page

Dow Jones
Starting Member

1 Posts

Posted - 11/20/2008 :  05:57:30  Show Profile  Reply with Quote
Hi,

Are you aware of any other similar tools?

Have you tried Quest Discovery Wizard for SQL Server(http://www.quest.com/landing/?ID=1305)? It's freeware. I found it helpful in my tasks a couple months ago...
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000