A way of detecting MSSQL active servers in LAN.
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   Horatiu_Ripa
Posted On:   Thursday, November 7, 2002 10:55 PM

Does anybody knows a way to detect active MSSQL servers in a LAN?

Report | Quote This | Send private message | Reply | Print

Re: A way of detecting MSSQL active servers in LAN.

Posted By:   Horatiu_Ripa  
Posted On:   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.
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact