MSSQL: List SQL all network SQL server from the command line
From a command prompt use the follow:
To send to a file use: sqlcmd -L >sqllist.txt
The older commands are isql and osql
I also use the “Data Sources (ODBC)” connector from Administrator Tools and start the creation of a System DSN. From the SQL Server drop down box you can see the ones advertising themselves.