Versions Compared

Old Version 2

changes.mady.by.user user-cd56b

Saved on

compared with

New Version 3

changes.mady.by.user user-cd56b

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Please note that when employing Entra ID authentication while adding a new server to SQL Diagnostic Manager offers you different types of authentication connections, such as:

  • Windows Authentication
  • SQL Server
  • Entra ID

Windows Authentication

Windows Authentication is the recommended collection type as SQL Diagnostic Manager uses many SQL trace statements that require a trusted connection. When you choose to use Windows Authentication, the SQLdm Collection Service uses the account it is running to connect to the SQL Server instance.

SQL Server 

SQL Server Authentication is the typical authentication used for various database systems and requires a username and a password. You can use this type of authentication when using shared servers to access different databases or using a remote computer or connection.

, you must select or configure an Azure Profile.

Info

Components of Azure Profile are responsible for building a valid connection.

How to select an Azure Profile?

Select your Azure Profile by following the next steps:

  1. Click the Azure Discovery Settings button.
  2. In case you have already created an Azure profile, select it from the Selec an Azure Profile dropdown. Otherwise, create a new one.
    Image Added
  3. Click OK to save your configuration.
  4. Select a server to monitor.
  5. Select the instances to monitor.

Anchor
NewAzureProfile
NewAzureProfile
How to create a new Azure Profile?

Create a new Azure profile by clicking Manage Azure Profile from the Azure Application Configuration wizard.

When the Azure Profiles Configuration Wizard opens, you have two sections:

  • The Application Profile adds a new profile and manages the existing profile.
  • The Azure Linked Profile indicates which Azure profile is linked with which server instance. You can also manipulate this mapping using the View/Edit and Delete buttons.

To add a new Azure profile please follow the steps below:

  1. Click the New button from the Application Profiles section.
    Image Added
  2. Choose a Profile Name and Description for your Azure profile, from the Azure Application Profile wizard.
    Image Added
  3. Select an Azure Subscription from the subscription dropdown, otherwise, click New and complete the following fields with the application information:
    1. Subscription ID*
    2. Description
      Image Added
      Info

      (*) This information is mandatory, to get it from your application follow the steps outlined in theHow to get Azure Profile components? section.

  4. Click OK to save your Subscription information.
  5. Select an Azure Application from the application dropdown, otherwise, click New and complete the following fields with the application information:
    1. Application name
    2. Tenant ID*
    3. Client ID* 
    4. Secret value*
    5. Description of the Azure application
      Image Added
      Info

      (*) This information is mandatory, to get it from your application follow the steps outlined in the How to get Azure Profile components? section.

  6. Click OK to save your Subscription information. Review all your information. When you finish, the wizard should look like this image.
    Image Added
  7. Click OK to save your Azure Application Profile.
  8. Click Close to close the Azure Profiles Configuration wizard.
  9. Select the Azure Profile just created from the Select a Profile dropdown.
  10. Select the instances to monitor.

Anchor
getAzureProfileComponents
getAzureProfileComponents
How to get Azure Profile components?

In case you do not know how to obtain your Application information such as Subscription ID, Tenant ID, Client ID, and Secret value, we outlined the following steps to get them.

Get your Subscription ID

  1. Login to Azure Portal.
  2. Get the Subscription ID by searching Subscriptions on the search bar.
  3. Copy and save the Subscription ID in a notepad or secure file.
    Image Added

Get your Tenant ID

  1. Login to Azure Portal.
  2. Select the Microsoft Entra ID service.
    Image Added
  3. Copy and save the Tenant ID from the Overview tab.
    Image Added

Get your Client ID and Secret Value

  1. Login to Azure Portal.
  2. Select the Microsoft Entra ID service.
    Image Added

  3. Navigate to the Manage node from the left side menu and select App Registration.

  4. You can choose an existing owned app or create a new registration by clicking the New Registration button.
    Image Added

  5. If you have already created your  Owned App select it and the Overview page will display the Client ID.
    Image Added

  6. Copy and save it.

  7. Click the secret hyperlink to obtain your Secret value if you have already created it. In case you need a secret value, you can create a new one.

  8. Copy and save your Secret Value.

Create a Client Secret

In case you do not have the Secret ID or you lost it, follow the steps below: 

  1. Navigate through the Manage node to the Certificates & secrets option from the Overview tab of your Owned App.
  2. Click the New client secret option.
    Image Added
  3. Choose a description, select an expiration time from the dropdown menu, and click Add.

  4. Copy and save the Secret ID.
    Image Added
Warning

You must save the Secret value once you create the Client Secret, otherwise, the next time you log in to the Azure Portal to check this value, it will be masked.

If you lost or did not save the Secret value and you need it, create a new Client Secret and use the new Secret value.

...