To access the cloud instances discovery options click Cloud on the left pane of the Discovery Center Options view.
Besides SQL Server login, discovering and adding instances require the same set of credentials. When registering (adding) and instance we are also asking for the sql server login (which we are not asking for during discovery).
There are 2 scenarios
Scenario 1: Instance is discovered using cloud account. In this case, the account is already associated with this instance so API calls will be using this account
Scenario 2: Instance is not discovered, but added directly from add instance screen
in this case, api will be using account details added via add instance wizard
When adding an instance, the cloud details are optional. User can choose not to add these. If they do not specify the cloud account details, the following metrics cannot be retrieved
starting from line number 56 to 67 in this doc:
https://docs.google.com/spreadsheets/d/1BmIdiQ0X9ebjLIQN7SLMJxbqn_QNeKy4szHl71oDrcc/edit?ts=5bb269f8#gid=0
Sql server login is mandatory when registering an instance
Discovering Amazon Instances
The Amazon tab on the Cloud Discovery Settings section allows you to set and edit Amazon accounts for discovering instances.
Before you begin
Make sure you perform these steps before adding an Amazon account on SIM.
- Create an AWS account as trusted entity for read-only role on the main AWS account where SQL Inventory Manager discovery will be running.
- Create a read-only role on the user’s main AWS account (where SQL Inventory Manager discovery will be running)
Adding an Amazon account
For Amazon: "Specify the account to be used to connect to the Amazon EC2 or RDS instance. Amazon account information is needed to collect performance metrics. Please note that you may see charges from Amazon for Cloudwatch API requests. Click here [insert url to wiki page] for more information."
Click Add Amazon Account and enter the following information on the Amazon Account dialog.
AWS Account Name: Name for referencing the AWS account
AWS Access Key: Access ID
AWS Secret Key: Secret access key information
AWS Region Endpoint: Select your Amazon region
Editing an account
To edit an Amazon account click on the gear icon next to the account name you want to edit and select Edit. Once you modify your information on the Add/Edit dialog click Save to save your changes.
Removing an account
To remove an Amazon account click on the gear icon
next to the account name you want to remove and select Remove.Note: All the instances discovered before removing an account remain on the Discovered View.
Discovering Azure Instances
The Azure tab on the Cloud Discovery Settings section allows you to set and edit Amazon accounts for discovering instances.
Adding an Amazon account
Click Add Azure Account and enter the following information on the Amazon Account dialog.
Name: <Short Description of what it is>
Azure Tenant ID:
Azure Client ID:
Client Secret Key:
Editing an account
To edit an Azure account click on the gear icon
next to the account name you want to edit and select Edit. Once you modify your information on the Add/Edit dialog click Save to save your changes.Removing an account
To remove an Azure account click on the gear icon
next to the account name you want to remove and select Remove.