list of sql server running in my domain
-
I'm looking for a way to find what servers are running SQL Server in my domain?
-
Checkout the scanners available over at http://www.sqlsecurity.com
--------------------
Colt 45 - the original point and click interface
-
I already know about tools like SQLPing, I was hoping someone and another script or something, beside a 3rrd party tool.
-
You can also do this from the command line:
osql /L
From BOL: This option lists the locally configured servers and the names of the servers broadcasting on the network
-
... and if they're not braodcasting on the network, they won't be listed. That's why a third-party tool is best.
--------------------
Colt 45 - the original point and click interface -
Linche Shea's book "Real World SQL Server Administration with Perl" has a great script called scanForSQLServer.pl. This script has the benefit of showing you BOTH all SQL servers across on your domain(s) and also showing servers that have NULL sa passwords.
I cannot recommend this book highly enough. It has saved me a lot of time and grief as a DBA. Check it out: http://www.apress.com/book/bookDisplay.html?bID=171.
G. Milner
-
I've had good luck 'free' third party tool like SQL Recon from Special Ops Security. Once you install a tool like this you'll need to speak with your network folks and get a list of IP address ranges at you site (e.g. 10.172.0.0 - 10.172.254.254, 10.10.0.0 - 10.10.254.254) and scan the ranges. Otherwise a scan of a range like 10.0.0.0 - 10.254.254.254 may take a week to run !
Beware if you are on a 'switched' network (some of these scripts will not find everything). Also, secure fire-walled subnetworks can be an issue as well (boy do I know this one !).
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply