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