MAC support for Azure Directory Interactive (with MFA support) login

Hi,

Microsoft does not offer official support for any of the Azure Active Directory authentications for macOS. Consequently, there is no ETA on adding those authentication mechanisms to RDM Mac.

Best regards,

Hi,
for mac and iphone users i was tring to workaround as following:

• login in microsoft MFA Setup
• Create an app password

then, back to RDM

• Use database login and insert the username@domain.com as login
• insert the app password

But i get as error "unable to connect to server "domain.com" (part of my username)
I suppose is because of the connection has problems with "@"
is possible to fix so we cano fully implement azure AD auth?
Thanks

Hello,

I have talked to our architects and it is an intended behaviour by RDM and the communication with Azure so we can't really fix it.

Although, recent documentation seem to suggest they have expanded the .Net frameworks that can use azure AD and they will look into it:
https://docs.microsoft.com/en-us/sql/connect/ado-net/sql/azure-active-directory-authentication?view=sql-server-ver15

Sadly we still can't give an ETA because we need to look into it first and see if we can integrate the changes.

I hope this answered your questions.
Best regards,

Any update on this matter? Has been 7 months ago :)

Hello,

I have talked to our architects and it is an intended behaviour by RDM and the communication with Azure so we can't really fix it.

Although, recent documentation seem to suggest they have expanded the .Net frameworks that can use azure AD and they will look into it:
https://docs.microsoft.com/en-us/sql/connect/ado-net/sql/azure-active-directory-authentication?view=sql-server-ver15

Sadly we still can't give an ETA because we need to look into it first and see if we can integrate the changes.

I hope this answered your questions.
Best regards,

Hi,

Unfortunately, we have no news on this yet.

Best regards,

Oh! Nevermind, I was to hasty in my previous post.

I have news, but bad one unfortunately.

We did try to make the update to the more up to date library, but sadly, it references another library that is unavailable for macOS (more precisely, Microsoft.Data.SqlClient.SNI.runtime).

We can see in the README of the GitHub page that this library (SNI) is only provided for Windows platform.

We will keep the ticket opened for investigation, for the case where either Microsoft update the library for cross-platform support or if we find some alternative means to do this.

Best regards,

Alright, thanks for your response. I hope it will work one day :)

Oh! Nevermind, I was to hasty in my previous post.

I have news, but bad one unfortunately.

We did try to make the update to the more up to date library, but sadly, it references another library that is unavailable for macOS (more precisely, Microsoft.Data.SqlClient.SNI.runtime).

We can see in the README of the GitHub page that this library (SNI) is only provided for Windows platform.

We will keep the ticket opened for investigation, for the case where either Microsoft update the library for cross-platform support or if we find some alternative means to do this.

Best regards,

Look like a new version is coming out! also there is some better native sso support for MacOS and in the coming version MacOS Ventura they will add full support azure ad auth login on the os itself. Maybe you guys could take another sneek peek in what is possible here, that would be really great :D

Hi info57,

I'll update the ticket with this new information and raise the priority.

Best regards,

Hi info57,

I'll update the ticket with this new information and raise the priority.

Best regards,

Can you give an update on this matter? Any progress already?

Hello,

This is still on the to-do list of our Engineering Department.
We will be in touch as soon as progress will be made on that matter.

Best regards,

Is it possible to update the app to use the Apple Enterprise SSO so that it can call the Azure AD SSO plug-in that is part of Company Portal? https://learn.microsoft.com/en-us/azure/active-directory/develop/apple-sso-plugin

Hi,

Thanks for this. We will look into this when we get a chance.

Best regards,

Hi!
I hope this is still on the to-do list, and getting futher towards the top. If (when) this feature is added, a big hole in my move-to-mac plan is filled.

Hi,

It's still in the todo list. But this has to wait for our migration to .Net 7/8. We can't work on this until then. So it wont be until next year at the earliest.

Best regards,

We are also waiting for this. Support for logging into Azure Database with AD/Azure-user is much needed from MacOS. Is there any progress? .Net is now on version 8.

Hello

A new version of RDM Mac is available (2024.1.8.6)
and AD interactive for SQL Server should now be available.
If there's anything, don't hesitate to communicate with us.

Best regards,

You made my day :) Have been waiting a long time for this. Thanks!