Tools to Scan for SQL Servers - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

Other Topics

Tools to Scan for SQL Servers

Author

Topic

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-06-20 : 17:05:25

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

30421 Posts

Posted - 2007-06-20 : 17:12:46

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

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-06-20 : 17:21:55

[code]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[/code]

Peter Larsson
Helsingborg, Sweden

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-06-20 : 18:00:14

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

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-06-20 : 18:58:35

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

Dow Jones
Starting Member

1 Post

Posted - 2008-11-20 : 05:57:30

Hi,

Are you aware of any other similar tools?

Have you tried Quest Discovery Wizard for SQL Server([url]http://www.quest.com/landing/?ID=1305[/url])? It's freeware. I found it helpful in my tasks a couple months ago...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources