Get the Sql instance name of a server

Get the Sql instance name of a server by using portquery

Run form command

portqry -n 'server name or IP address' -e 1434 -p udp

e.g.

portqry -n 192.168.1.20 -e 1434 -p udp

Help Link :

http://support.microsoft.com/kb/832919

Download Link:

http://www.microsoft.com/downloads/details.aspx?familyid=89811747-C74B-4638-A2D5-AC828BDC6983&displaylang=en