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 ports SQL Server uses to listen. The standard ports are 1433 and 2433. |
| 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.
...
To find new or rogue SQL Server instances using SQL Discovery:
- Open the Idera 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.
- 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.
...
SQL Admin Toolset delivers 24 essential administration tools. Learn more > >
...