Page History
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 windowProperties 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:
- Overview Home tab - Edit properties option on The Edit Instance Properties option is located on the gear icon menu next to the instance nameyou want to edit.
- Instance details view - The Edit Instance Properties option is located under the gear icon next to the instance name.
- Instances tab > Managed by Instances view - The Edit Instance Properties option is located Edit properties option on the action items bar.Instances > Managed view - Edit properties option on the gear icon menu next to the selected instance or instance you want to disable, or under the Edit Instance on the action items bar. Note that you must select at least one instance to have this option enabled.
- Instances > tab > SQL Licensing view by Instances view - Edit properties option on The Edit Instance Properties option is located on the gear icon menu next to the selected instance or instance you want to disable, or under Edit Instance on the action items bar.
Below you can see the tabs and sections where you can find Edit instance properties. Click the image to view full size.
Gallery | ||||
---|---|---|---|---|
|
- Note that you must select at least one instance to have this option enabled.
Tip | ||
---|---|---|
| ||
On the Instances view, on the Managed instances 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 Managed Manage by Instances view, refer to Managed instancesInstances. |
...
For Windows Instances
Editing Owner, Location and Comments
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 propertiesInstance Properties window, make the necessary changes, and then click SAVE.
SQL Server connection credentials
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 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.
Note | ||
---|---|---|
| ||
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. |
...
User credentials
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 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.
Note | ||
---|---|---|
| ||
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. |
For Linux Instances
Editing Owner, Location and Comments
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.
SQL Server connection credentials
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.
Note | ||
---|---|---|
| ||
When IDERA SQL Inventory Manager has the auto-registration option enabled, it uses the IDERA SQL Inventory Manager service account as the default WMI connection credentials.SQL Server connection credentials. Credential settings for auto registered instances can later be changed in the Edit Instance Properties option. |
Connection Credentials
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:
- Go to the Connection Credentials section and choose User Credentials.
- Provide a valid login and password.
- After you define your Credentials, you can click Test Credentials to make sure IDERA SQL Inventory Manager can use these credentials to gather data from host computers.
Querying information from Linux
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:
- Hardware cores
- VM cores
- OS (eg: Ubuntu)
- OS Version (eg: 14.2)
Querying Linux requires several commands be issued to obtain:
- CPU Make, Model & Speed
- Server manufacturer
- Disks
Those commands include:
- $ dmidecode (board related data)
- $ lscpu (more specific CPU data)
- $ df or other (disks)
- $ uname to return OS
SIM sysadmins must provide one or more users (either Linux or AD) to query Linux. These users need only login and read rights.
Info | ||
---|---|---|
| ||
For more information on what permissions you need for any of these accounts, see Required accounts and permissions. |
Need more help? Search the Idera Customer Support Portal.
...