Connect to Azure with active Directory

[MariaD]

Hi Folks,

We have 9.4 and currently, we're connecting to Azure Synapse using Access to MS SQL Server and nominal users. Is it possible to allow access through Active Directory group instead? I understand if we change the configuration on SQL Server driver to "TrustedConnection=yes" we can use Active Directory as a user validation process, but if we'd like to use AD groups? 

Regards, 

[SASKiwi]

If you allow access at the AD group level, then as long as your users belong to that group they should be able to continue to use Trusted_Connection=yes.

[MariaD]

Thanks!