Page History
IDERA SQL Inventory Manager allows you to specify alternate credentials to use during the discovery process in case the original credentials are not valid. Manage Discovery Credentials lets you enter multiple discovery credentials and specify the order in which you want IDERA SQL Inventory Manager to attempt to use when connecting to a server.
To configure these options, go to Manage Discovery Credentials on the Administration tab.
What options can you set for Discovery?
Configure Browse service and Computer scan
You can set your preferred schedule for a Browser service scan and Computer scan. SQL Inventory Manager uses the Browser service scan to run the general discovery of SQL Server instances while the Computer scan is used to obtain a list of machines based on IP ranges or domains.
You can set the schedule of your preference (Daily, Weekly) for any of the mentioned scans. If you choose a Daily schedule, then set the specific time for the discovery job. if you set a Weekly schedule, specify the days of the week and the time when the scan will be performed.
Add IP address ranges for discovery
Use this section to specify those IP address ranges where SQL Inventory Manager will run scheduled discovery jobs. On this section you can:
- Click Add and enter the IP address ranges that you want SQL Inventory Manager to take into account for discovery jobs. You need to specify the type of account that SQL Inventory Manager will use to gather host computer information. Select Enable on those IP address ranges where SQL Inventory Manager will run the scheduled jobs.
- Click Edit to change the IP address ranges you entered before to edit their credentials, the IP range information, or enable/disable them for scheduled jobs.
- Click Remove to delete any available IP address ranges.
- Additionally, you can select those IP addresses where you want to run an immediate scan. After selecting your IP addresses, click Run Scan Now.
Add Domains for discovery
The Manage Discovery Options allows you to add domains for discovering SQL Server instances. Go to the Domains section, click Add, and specify DNS Name, the domain name with the account that will be used to connect to this domain (User and Password). Select Enable if you want SQL Inventory Manager to use the domain for running scheduled jobs.
You can Edit/Remove the domains you entered before. You can also select those domains that you want to scan immediately by clicking Run Scan Now.
Specify scan methods and display options
Choose the methods you want to you use when scanning each computer for SQL Server instances. SQL Inventory Manager allows you to choose from:
- SQL Server Resolution Service
- Service Control Manager
- WMI
- TCP Ports
- Windows Registry
You can select more than one scan method.
When you select TCP Probe, you have to specify the ports that SQL Inventory Manager will use to scan.
Choose the way you want SQL Inventory Manager to display the results. Options include:
- Show instances discovered by at least two discovery methods
- Discover instances whose SQL Server version has been validated
| Tip |
|---|
Take into account that when executing WMI scans on large IP ranges, a No buffer Available Space exception may occur. For more information about this, click here. |
Need more help? Search the Idera Customer Support Portal.
The Manage Discovery Credentials window opens and displays a list of credentials that IDERA SQL Inventory Manager should use during discovery when attempting to connect to an instance. Credentials are used in the order in which they display, so make sure that the credentials appear in the proper order. To move a set of credentials, check that line, and then click Move Up or Move Down from the action menu.
Add credentials for discovery
The Manage Discovery Credentials window allows you to add credentials for discovering SQL Server instances. Click Add and IDERA SQL Inventory Manager displays the Add Discovery Credentials dialog box. Type the user name and password, confirm the password, and then click Save.
Change credentials password
Select one or more sets of credentials when you need to change a password. IDERA SQL Inventory Manager changes the password for all checked credentials. Click Change Password in the action menu, and IDERA SQL Inventory Manager displays the Change Password dialog box. Make the appropriate changes, and then click Save.
Remove credentials
If you want to remove a set of credentials from IDERA SQL Inventory Manager, select the appropriate set or sets of credentials, and then click Remove. Verify that the correct credentials are displayed in the confirmation message, and then click Yes.
...