Page History
...
| 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 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. |
...
Use Password Checker to test the security of the found SQL Server instances.
Use the SQL Discovery tool
To find new or rogue SQL Server instances using SQL Discovery:
- 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 in the previous window, specify one or more IP addresses that you want to scan.
- If you selected SQL 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.