Scan for SQL Instances

[mutley1]

Hi All,

I am currently finding servers in our vast array of machinery that have SQL installed on them, and the only thing is I never knew about most of them. Does anyone know of a tool that would scan our network to identify any machines that have any instances of SQL on them, including SQL 7, SQL 2000 and MSDE. I have the slammer scan, but that only picks up MDSE and 2000 - need to identify anything that has 7 on it as well.

Thanks,

Matt.

 

[pabloj]

Any portscanner should do the trick, check machines that have something listening on port 1433 (standard port).

Stick to your guns

 

[paul172]

Or you could kick off the 'New SQL Server Registartion' wizard within Enterprise Manager. The first screen will give you a list of all availble SQL servers on you LAN.

 

[mutley1]

Thanks Paul, but that only covers broadcasting servers.

 

[camy123]

do this mate... besically.. go to control panels ADD_REMOVE PROGRAMS... all your instances will be in there.

hope this helps.

 

[mutley1]

Hi Camy,

We have over 200 servers here and I want to scan the network to see which of them have it installed etc. as opposed to loggin in to every one!!

 

[grimwyre]

Try the netsvc command. Run it from a DOS box, you might need to have administrator access, and you will need to know the service name, and the name of each server, so it's best to set up a BAT file. I can't remember where netsvc came from, maybe bpart of some tool kit.

netsvc <service name> \\<server name> /query
eg netsvc MSSQLSERVER \\MyServer /query.

 

[camy123]

sorry mate .. ill come back to .. you on this..

 

[mutley1]

Thanks for the help all, but sorted with Pabloj's idea. Scanned all network for port 1433 listening.

 

[pabloj]

Fast and easy ;-)

Stick to your guns

 

[termita]

Hello,

How can I find SQL Server 2000 instances in the intranet, and how can I list them in a listbox (hostname\instance)?

 

[termita]

Sorry to post again, don't know how to edit my previous post.

I was wondering: how can I search the intranet for SQL Server 2000 instances, and display them somewhere, in this form: hostname\instance, so that I can choose which one to connect to? I need to do this in .NET (C#).

Thanks

 

[mutley1]

Hi Termita,

you can use the slammer scanner from microsoft. The other program is Advanced Port Scanner. You enter a range of addresses / ports (can limit it to the 1 port, 1433 which SQL listens on) and it tells you if it's open or closed. Doesn't give instances, but telly you what prob has SQL on it. Not sure where you can find advanced port scanner V1.2, but just search as it is freeware.

Matt.

 

[SQLBill]

Microsoft used to have a tool on it's SQL web site which would search for instances of SQL Server 2000. I haven't been able to find it recently.

Searching for TCP Port 1433 is good. But any DBA who is up on security has 1) blocked that Port at the firewall or 2) changed the TCP port that SQL Server uses.

-SQLBill

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine

Posting advice: FAQ481-4875

 

[mutley1]

Thanks Bill.....trust me...they're blocked on the firewall this end!

 

[SQLBill]

Then if they are blocked a scan for port 1433 won't find anything, which is the point I was trying to make.

-SQLBill

 

[Corran007]

unless you have internal firewalls in your company, since its an intranet they should still be visible since your not actually going through the firewall. unless im missing something here.

 

[SQLBill]

Sorry, I keep thinking about internal firewalls since my company uses both.

-SQLBill

 

[mutley1]

No Corran - that's the setup we have, as in anything from external trying to access 1433 will be denied, but I am on the inside......with the little gremlins...he he.