Azure SQL Database using Azure AD identities

Hi,

I have entered a feature request.

Is there any word about this feature? Azure AD login (with MFA) would be a nice option.

What also would be nice is the ability to use Azure AD accounts (with MFA) with Devolutions Server.

I know you can use google authenticator etc, but as we are using Office 365 users are already using Azure AD accounts protected with MFA, and it would be nice if they could just use that instead of configuring yet another two-factor solution/app.

Hi,

I will confirm with Martin if it's exactly what you want because I know that DVLS now support Azure MFA

Regards

I've checked the information about DVLS and Azure AD, but there are some issues with this i think:

- I need to download some sdk from the azure portal, but we don't use multi-factor auth provider (our MFA is included in our Office 365 licenses).

- It only supports SMS or Phonecalls (who still uses that? :) ) , an azure AD based login should just use the settings the (azure AD) user has already set up (most likely he uses the Azure MFA app).

- allowing 'real' azure ad logins would circumvent the problems above, and would make for a better experience (but i have no clue about programming, so i have no idea if its even possible), integration azure ad login in webapp is (supposed to be) a breeze, but for applications things are probably not so easy.

Hi,

You are right about the MFA SDK, it needs a auth provider to be configure and download the SDK file from Azure and it only supports SMS and Phone call.

DVLS support MFA SDK for now!

Let me check different options

Best regards

Hi, guys!

It would be great, if we would have the ability to login to AzureSQL datasources using AzureAD accounts, even without MFA.

We really need it.

Hi,

Microsoft has just released the SQL Server Management Studio with this. We will add this to our todo list but it won't be for RDM 12 for sure. This version is planned for the end of September.

Regards

+1 on this, Active Directory integrated authentication would be a great security improvement with Azure SQL

Hi David,

Any news on this? For us it would be an important feature to use AzureAD accounts on AzureSQL

Nothing new for now but that something we will investigate right after the RDM 12 release.

Regards

RDM 12 has been released. Is there a time frame for this feature?

+1 on this feature. This is holding us back from deploying company wide.

It's the next feature on my to-do list. We start our holiday vacation break at the end of the week. Once back in the new year I will be starting on this. Should have something shortly after that. It's currently the most asked feature request.

Best regards,

We do.