How to register Data Compare as a Microsoft Entra ID application

Last modified: September 6, 2024

To connect to an Azure database with the Microsoft Entra MFA authentication, you should register dbForge Data Compare for SQL Server as a Microsoft Entra application and set permissions. During the registration, an application ID will be generated automatically.

To register Data Compare as a Microsoft Entra ID application:

1. Sign in to the Azure portal.

2. In Azure services, click Microsoft Entra ID. Then, select Add > App registration.

3. On the Register an application page, enter dbForge Data Compare in the Name field and click Register.

Note

After dbForge Data Compare has been registered as an application, the application ID is generated automatically. It is a unique and unchangeable identifier for dbForge Data Compare for SQL Server. You need to copy and save it to connect dbForge Data Compare for SQL Server to the Azure database.

4. On the page that opens, click Add a Redirect URI.

5. On the dbForge Data Compare > Authentication page, click Add a platform and then click Mobile and desktop applications.

6. In the Configure Desktop + Devices window, select https://login.microsoftonline.com/common/oauth2/nativeclient as a redirect URI and click Configure.

7. On the Authentication page, switch to the Advanced settings section, turn the toggle switch next to Allow public client flows to Yes, and then click Save.

8. In the Azure portal, click API permissions and then click Add a permission.

9. In the Request API permissions window that opens, switch to the APIs my organization uses tab and start typing Azure SQL Database in the Search field.

10. From the drop-down list, select Azure SQL Database.

11. Click Delegated permissions, select the user_impersonation checkbox, and then click Add permissions.