Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In order to manage an instance, access its details, and add it to your monitored environment, you need to register it with IDERA SQL Inventory Manager. This section helps you register one or more instances with IDERA SQL Inventory Manager. 

You can find the Add SQL Server Instance option on the following views:

...

  1. Type the name of instance or instances you want to register in the SQL Server Instance box. Use a semicolon to separate instances.

    Tip

    When you select instances on the Discovered or Ignored Instances views, the wizard already adds them to this box.


    You can use the Browse button to access a list of discovered instances that have not been registered yet with IDERA SQL Inventory Manager.

  2. Check the box next to the instances you want to add, and click Apply.
  3. Click Next to go to the next section.

2. Credentials

IDERA SQL Inventory Manager connects to registered SQL Server instances and their host computers to collect information. The collection service requires permissions to connect and gather information using the following types of connections:

...

Info
titleAuthorize WMI users and set permissions

If you want to know how to authorize WMI users and set permissions, click here.

By default, IDERA SQL Inventory Manager connects using the IDERA SQL Inventory Manager Service AccountManager service account. However,if you need to provide alternative credentials for any of these two connections, you can choose from the respective options on each section.

...

  • If you select a Windows user account or SQL Server login account, type the respective user name and password.  SQL   IDERA SQL Inventory Manager uses this account for SQL queries to gather availability and configuration data.

...

Tip
titleTip

IDERA recommends that you use the Test Credentials option to verify that IDERA SQL Inventory Manager can successfully monitor the newly registered instances.

...

Tip
titleTip

Refer to the Managing Tagstags section for more guidance on how to add, view, edit, or delete tags.

...

After you review your registration details click FINISH. IDERA SQL Inventory Manager begins to collect instances information after a few minutes of their registration and will continuously collect availability, performance, and configuration information from them and their host computers.

...