> For the complete documentation index, see [llms.txt](https://docs.devolutions.net/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.devolutions.net/rdm/getting-started/workspaces/workspace-types/alternative-workspaces/microsoft-azure-sql/enable-entra-id-authentication/configure-active-directory-interactive-with-mfa-support-in-remote-desktop-manager.md).

# Configure Active Directory Interactive with MFA support in Remote Desktop Manager

Configure Active Directory Interactive with MFA support in Remote Desktop Manager to sign in to Azure SQL using Office 365 credentials.

**Active Directory Interactive (with MFA support)** allows you to authenticate to your [Microsoft Azure SQL](https://docs.devolutions.net/rdm/getting-started/workspaces/workspace-types/alternative-workspaces/microsoft-azure-sql.md) workspace using your Office 365 credentials with multi-factor authentication (MFA).

{% hint style="danger" %}
When creating Azure SQL Active Directory users, you must be signed in with an Entra ID account. If not, the operation will fail and an error message will be displayed.
{% endhint %}

Use the server’s defined Entra ID administrator account to create your first Remote Desktop Manager administrator user. Once created, you can use this new account to create additional ones.

### Setup

1. In Remote Desktop Manager, go to ***File*** – ***Workspaces*** and click on ***Add a new workspace***.
2. Select the ***Microsoft Azure SQL*** workspace type.
3. Specify the ***Name*** and ***Host*** of your workspace.
4. In the ***Login mode*** drop-down menu, select ***Active Directory Interactive (with MFA support)***.
5. In the ***Username*** field, paste the ***Active Directory admin*** email you created in Microsoft Azure SQL Database.

On the first connection, the username must be that of the Entra ID administrator, as defined in [Configure the Entra ID administrator](https://docs.devolutions.net/rdm/getting-started/workspaces/workspace-types/alternative-workspaces/microsoft-azure-sql/enable-entra-id-authentication/configure-the-entra-id-administrator.md). Once additional AD users are added in Remote Desktop Manager, they will be able to connect as well.

{% hint style="warning" %}
If you receive the error message “Unable to connect to the database! Login failed for user '\<token-identified principal>'.“ , verify that the username is spelled correctly.
{% endhint %}

6. Enter the name of the ***Database*** you want to authenticate to.
7. Click ***Add***.

When you choose ***Active Directory Interactive (with MFA support)***, Remote Desktop Manager has no control over the login prompts. The authentication request is sent to the Microsoft library, and all subsequent prompts are handled entirely by Microsoft.

Here are some considerations:

* Have any conditional access policies been added or modified recently that could explain a change in behavior?
* If you're using an Entra ID-joined machine, you might try using Active Directory Integrated to see if it provides a smoother experience.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.devolutions.net/rdm/getting-started/workspaces/workspace-types/alternative-workspaces/microsoft-azure-sql/enable-entra-id-authentication/configure-active-directory-interactive-with-mfa-support-in-remote-desktop-manager.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
