Setting up identities in Azure

When using the Microsoft Entra Managed Identity as an authentication method, Azure is automatically taking care of creating and maintaining all the needed registrations in Microsoft Entra. Please continue to the next section.

When using the Microsoft Entra Service Principal as an authentication method, a Microsoft Entra App Registration needs to be created.

In order to create a Microsoft Entra App Registration please follow the instructions from Microsoft Documentation linked below. Please make a note of the Application name and the Client ID of the newly created Microsoft Entra App Registration as you will need it later when setting up SQL Tran. Skip the „Add a redirect URI“ section considering it is not needed by SQL Tran. In the „Add credentials“ section select the „Add a client secret“ tab and make note of the secret as you will need it later when setting up SQL Tran.

https://learn.microsoft.com/en-us/entra/identity-platform/quickstart-register-app

At the end, you should have three pieces of information noted which you'll need in next steps:

• Client Secret

• Client ID

• Application Name