Discover all SQL Servers on the Network – Searching SQL Server
Finding all SQL Server on the network.
This is a simple SQL utility software that helps to discover SQL Servers that are installed and broadcasting on the local network and in the local machine.
(Please change the file extension. It is named as DiscoverSQLServers.pdf, but we have to rename to DiscoverSQLServers.exe)
This tool has three sections
Section 1: Discover SQL Servers, To start the search we have to press the “Start Discover” button. After the search is completed, all server names with instance name will be listed in list box. We can select a sever name from this list to construct the connection string.
Section 2: This is a table that will load all server name, instance name, flag for clustered server and version number. This details help us to understand our SQL Server environment.
Section 3: This is a simple but powerful section to auto construct the connection string for the selected server. In this section, we can test the validity of the connection string by pressing “Test Connection” button and by default, it will build the trusted connection. But, we can change that to SQL authentication by simply check the “SQL Authentication” option. It will pop-up user input dialog box for username and password. We can also copy the connection string to the clipboard to paste it in your code.
This is simple but powerful tool available for download.
(Please change the file extension. It is named as DiscoverSQLServers.pdf, but we have to rename in to DiscoverSQLServers.exe)
Please write your review about this tool in the comment section. I am glad to hear from you. Thank you.
Other tools that can be used for this purpose
SQLO – it will be deprecated in future version.