Re: A way of detecting MSSQL active servers in LAN.
Sunday, November 10, 2002 11:11 PM
I find it myself. If somebody else is interested in the subject here is the solution:
Each MSSQL server has a SQL Monitor that waits on 1434 port for UDP packets. So you can find the MSSQL servers in a LAN by sending to the broadcast IP adress (255.255.255.255) on port 1434 the packet 0x02. All the MSSQL servers will respond with a string containing their active instances.