How to manage discovery credentials

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

The Manage Discovery Credentials window opens and displays a list of credentials that 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 SQL Inventory Manager displays the Add Discovery Credentials dialog box. Type the user name and password, confirm the password, and then click Save.

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

 

Need more help? Search the Idera Customer Support Portal.