Hi Nandan,
With Azure SQL (logical) Server that either hosts a Data Warehouse (Synapse Analytics) or SQL Database, you can only have a single account as the Active Directory Admin. This account can either be an individual AD user or an AD group. Please see: Create
an Azure AD administrator for Azure SQL server
The
Additional considerations section details the limitation:
-
To enhance manageability, we recommend you provision a dedicated Azure AD group as an administrator.
-
Only one Azure AD administrator (a user or group) can be configured for an Azure SQL Database server or Azure Synapse at any time.
-
The addition of Azure AD server principals (logins) for managed instances allows the possibility of creating multiple Azure AD server principals (logins) that can be added to the
sysadmin
role. (Note: Does not apply to Synapse
Analytics)
-
Only an Azure AD administrator for SQL Server can initially connect to the Azure SQL Database server, managed instance, or Azure Synapse using an Azure Active Directory account. The Active Directory administrator can configure subsequent Azure AD database users.
You will need to deprovision the current AD Admin, identify an AD Group account in your tenant, and then add this identity to your Azure SQL (logical) Server. You can then add/remove individual AD user accounts to this AD Group who require AD Admin privileges
to the Synapse Analytics instance.
Please let me know if you require additional information.
Regards,
Mike