Page History
...
The Add Instance Wizard contains the following four sections:
1. Instance
...
/Cloud database
In the SQL Server Instance box, specify the SQL Server instances running on private hosts or cloud services (Azure or Amazon) Type the name of instance or instances you want to register in the SQL Server Instance box. Use a semicolon to separate instanceswith SQL Inventory Manager for monitoring. Separate multiple entries with a semicolon.
When you select instances on the Discovered or Ignored Instances views, the wizard already adds them to this box.
Note The addition of a cloud instance or database may incur in additional costs for data access on your Cloud Provider account. See more information here
You can use the Browse button to access a list of discovered instances that have not been registered yet with IDERA SQL Inventory Manager.- Check the box next to the instances you want to add, and click Apply.
- Select the type of instance you want to add, either Private / On-Premise, Amazon, or Azure.
- Click Next to go to the next section.
...
IDERA SQL Inventory Manager connects to registered SQL Server instances and their host computers hosts to collect information. The collection service requires permissions to connect and gather information using the following types of connections:
- SQL connection credentials to perform queries against registered instances.
- User connection credentials to gather data from the host computers.
- Active Directory account to gather information from Amazon or Azure.
| Tip |
|---|
For more information on what are the minimum required permissions for these accounts, click here. |
...
- Specify the type of account that you want to use to access your SQL Server instance and collect its information. If you do not want to use the SQL Inventory Manager service account, you can choose to use a User account or a SQL Server login account from the Account Type list.
- If you select a Windows user a User account or SQL Server login account, type the respective user name and password. IDERA SQL Inventory Manager uses this account for SQL queries to gather availability and configuration data.
- You can test the correctness of your credentials by clicking Test Credentials.
Connection Credentials
For Private / On-Premise Instances
- On this section, you can choose to use the SQL Inventory Manager service account or a User account by selecting either of them from the Account Type list.
...
| Tip |
|---|
IDERA recommends that you use the Test Credentials option to verify that IDERA SQL Inventory Manager can successfully monitor the newly registered instances. |
For Amazon and Azure
- On this section, you can optionally specify an account for connecting to Azure or Amazon.
| Tip |
|---|
IDERA recommends that you use the Test Credentials option to verify that IDERA SQL Inventory Manager can successfully monitor the newly registered instances. |
3. Information
On this section you can specify additional information for your instances like Owner, Location, Comments and Tags.
...
- The tag name must begin with an upper or lowercase alphanumerical character.
- Your tag name must have a maximum length of 20 characters.
- Only the following special characters are valid for tags: ! # @ ( ) ' . : - _ and embedded spaces.
...
| Tip |
|---|
| Refer to the Managing tags section for more guidance on how to add, view, edit, or delete tags. |
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.
...