Page History
...
SQL Discovery searches computers hosting SQL Server instances by specifying IP ranges, a list of computers, or servers registered with Active Directory or Network Browser Service. You can also use a number of different scans or probes to increase the effectiveness of your search. The following table displays a list of available probes and their purposes.
Type of probe | What it does |
---|---|
Active Directory Probe | Checks for SQL Server instances registered with Windows Active Directory. |
Browser Service Probe | Checks for SQL Server instances registered with Network Browser Service. |
Service Control Manager Probe | Checks with Service Control Manager for installed SQL Server instances. |
SQL Server Resolution Service Probe | Checks port 1434 to determine whether SQL Server instances are registered with the SQL Server Resolution Service. |
TCP Probe | Checks the standard or custom ports |
SQL Server uses to listen. The standard ports are 1433 and 2433. Type a specific port or ports in the available field to scan those ports. | |
Windows Registry Probe | Checks the registry on each computer to detect whether SQL Server services are installed. |
WMI Enumeration Probe | Checks for installed SQL Server instances by using WMI for the search. |
Once the results are available, you can review the list of discovered SQL Servers, see which probe found each instance, and check the configuration details of each instance.
...
- Open the IDERA SQL Admin Toolset Launchpad, and then click SQL Discovery.
- On the Welcome window, click Next.
- Select which scan technique you want to use to locate SQL Server instances on your network, and then click Next.
- If you selected IP Range IP Range in the previous window, specify one or more IP addresses that you want to scan.
- If you selected SQL ServerSQL Server(s) in the previous window, specify one or more SQL Servers or the server group on whose host computers you want to perform a scan. To specify multiple SQL Servers, separate each name with a semicolon.
- If you selected Computer(s) in the previous window, specify one or more computers to scan for SQL Servers. To specify multiple computers, separate each name with a semicolon.
- Click Next.
- Choose which probes you want SQL Discovery to run as part of the discovery process, and then click Finish. If you select to use a TCP Probe, type the SQL Server port(s) you want to scan.
- Review the scan results. To see more details about a discovered instance, select that instance from the Scan Results list, and then view the details displayed below.
- If you want to create a server group that contains these instances, click Save as Server Group.
- If you want to save the results, click Copy Results To Clipboard, or export the list as an XML or CSV file.
Scroll Ignore | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
Newtabfooter |
|
...
SQL Admin Toolset delivers 24 essential administration tools. Learn more > >
...
...