views:

143

answers:

1

Is there an easy way, using Java, to scan/search the local network for SQL Server database instances?

+1  A: 

You can get source code from the free SQLPing tool to port into Java if you want.

This uses several techniques for SQL Server discovery because there is no foolproof method. Examples:

  • what port is the instance on and SQL Browser is turned off?
  • is the server configued with shared memory only
  • SQL Services not running
gbn
I want to scan for ONLY the tcp/1433 port. I dont care about any of the other methods and so SQLPing is overkill.
djangofan