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

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

Below you can see the tabs and sections where you can find Add SQL Server instances. Click the image to view full size.

The Add Instance Wizard contains the following four sections:

1. Instance

To add an instance

  1. Type the name of instance or instances you want to register in the SQL Server Instance box. Use a semicolon to separate multiple instances. Check Cloud Instance if you want to search for Cloud-based instances.

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




    Use the Browse button to access a list of discovered instances that are not yet registered with SQL Inventory Manager. Check the box next to the instances you want to add, and then click Apply.


  2. Click Next to go to the next section.

2. Credentials

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:

For more information about the minimum required permissions for these accounts, see Required accounts and permissions.

If you want to know how to authorize WMI users and set permissions, see the Microsoft TechNet article, Authorize WMI users and set permissions.

By default, SQL Inventory Manager connects using the SQL Inventory Manager 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.

SQL Connection Credentials 
WMI Connection Credentials

3. Information

On this section you can specify additional information for your instances like OwnerLocationComments, and Tags.

Although none of these fields are required, Owner, Location, Comments, and Tags provide a powerful method for grouping instances and databases to help you organize your resources. Use these options to view information such as database counts, size, or activity, grouped by these fields. 

Use the Owner and Location drop-down lists to access the available options.

To add tags to an instance, you can do one of the following:

4. Finish

On this section, you can review your Instance Registration Details such as: instance name, SQL Connection Credentials, WMI Connection Credentials, Owner, Location, Comments, and Tags.

To change any of these registration details you can do one of the following:

After you review your registration details click FINISH. 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.

After registration, you can still change credentials, tags, and information settings on the Edit Properties option. Refer to Editing instance properties for more information.

About collection intervals

Collection intervals are predefined. You can see more information about collection frequency on the What Health Checks are available in SQL Inventory Manager? section.

You can also force data collection for an instance by selecting Refresh Data on the Instance details view. For more information, refer to Viewing instance details.

 

Need more help? Search the Idera Customer Support Portal.

Idera WebsiteProductsPurchaseSupportResourcesCommunityAbout UsLegal