When you register an instance, you define certain properties such as credentials, owner, location, and comments. You can change this information from the Edit Instance Properties window, the available options depend on whether you are editing a Windows SQL Server instance or a Linux SQL Server instance. To access this window, go to any of the following views:
On the Instances view, on the Managed by Instances section, you can also select several instances at once and click Edit Owner, Edit Location, or Edit Credentials for faster editing of these fields. For more information about what you can do on the Manage by Instances view, refer to Managed instances. |
You can define owner, location, and comments when you register an instance; however, if you did not or you want to change any of these fields, go to the respective sections on the Edit Instance Properties window, make the necessary changes, and then click SAVE.
These credentials allow you to connect to SQL Server instances to collect availability, capacity, and configuration data. When you register an instance, you define these credentials; however, you can change them later on the Edit Instance Properties window.
You can choose between the IDERA SQL Inventory Manager service account, a Windows user account, or a SQL Server login account. The last two options require that you provide the respective login and password.
When IDERA SQL Inventory Manager has the auto-registration option enabled, it uses the IDERA SQL Inventory Manager service account as the default SQL Server connection credentials. Credential settings for auto registered instances can later be changed in the Edit Instance Properties option. |
These credentials allow you to connect to the computer that hosts the SQL Server instance, and collect its performance and computer details. When you register an instance, you define these credentials; however, you can change them later on the Edit Instance Properties window.
You can choose between the IDERA SQL Inventory Manager service account or a Windows user account. You need to provide a login and password for the Windows user account.
When IDERA SQL Inventory Manager has the auto-registration option enabled, it uses the IDERA SQL Inventory Manager service account as the default SQL Server connection credentials. Credential settings for auto registered instances can later be changed in the Edit Instance Properties option. |
You can define owner, location, and comments when you register an instance; however, if you did not or you want to change any of these fields, go to the respective sections on the Edit Instance Properties window, make the necessary changes, and then click SAVE.
These credentials allow you to connect to SQL Server instances to collect availability, capacity, and configuration data. When you register an instance, you define these credentials; however, you can change them later on the Edit Instance Properties window.
For Linux, you need to use a user domain account with SQL access when the instance is on a domain, or a SQL Server login account when the instance is not on a domain. This options require that you provide the respective login and password.
When IDERA SQL Inventory Manager has the auto-registration option enabled, it uses the IDERA SQL Inventory Manager service account as the default SQL Server connection credentials. Credential settings for auto registered instances can later be changed in the Edit Instance Properties option. |
These credentials allow you to connect to Linux systems that host SQL Server for Linux instances in order to collect their performance and computer details, specify a user or domain user account that can connect to Linux server. To change these credentials, follow these steps:
To query a Linux host for CPU, server and disk information, it is required to have credentials to SSH to that server.
Certain information may be found querying SQL Server:
Querying Linux requires several commands be issued to obtain:
Those commands include:
SIM sysadmins must provide one or more users (either Linux or AD) to query Linux. These users need only login and read rights.
For more information on what permissions you need for any of these accounts, see Required accounts and permissions. |
SQL Inventory Manager Discover and visualize your SQL Server environment. |