Home > SQL Server, Tools > Discover all SQL Servers on the Network – Searching SQL Server

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.

Download DiscoverSQLServers Now

(Please change the file extension. It is named as DiscoverSQLServers.pdf, but we have to rename to DiscoverSQLServers.exe)

pic1

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.

Download DiscoverSQLServers Now

(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.

SQLcmd

MAP – Microsoft Assessment and Planning (MAP) Toolkit

Advertisements
  1. Bill
    April 29, 2014 at 9:16 am

    I am having a problem downloading the file. I have tried both IE and Chrome. They both try to open the file as PDF. How do I rename it in order to download it?

    • April 29, 2014 at 9:33 am

      Hi Bill,

      Please right click on the link and select save link as option. If you still have problem please let me know. I can send it to your email.

      Thanks
      Ayyappan

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: