To be able to use the Active Directory Interactive (with MFA Support) authentication method in Remote Desktop Manager, a new app needs to be registered in the Microsoft SQL Azure console with the appropriate API permissions.
1.Login on Azure Portal.
2.In the Azure Active Directory section, select App registrations and then, New registration.
3.Configure the Name, Supported account types and Redirect URL as indicated below.
Supported Account Types
4.Click on the Authentication section and configure it as indicated below.
5.Click on the API Permissions section and configure it as indicated below.
6.Select Azure Active Directory Graph – Delegated Permissions – User – User.Read and click on Add Permissions.
Azure Active Directory Graph
7.We would need to add a second permission. To do so, select APIs my organization uses, then type Azure and select Azure SQL Database.
APIs my organization uses
8.Select Delegated permissions – user_impersonation and click Add permissions.
9.The API permissions should look like this.
API / Permissions Name
10.Your Azure Active Directory App Registration is now completed.
11.Copy the App Registration's Application (client) ID.
Application (client) ID
12.Paste the Application ID inside Remote Desktop Manager, in the App Registration section.