A user in Azure AD is added as a member to Azure Group that is Mapped to the Azure Principal login.
The Principal login has been assigned the required installation user permission sets as stated in 1IM installation guide under Permissions for installation users.
The Azure AD user account is then used to perform installation of 1IM on the Azure SQL Managed Instance.
However installation failed at Schema Installation step with the following error in the configuration wizard log:
"Processing step 'QBM ContentWaitForProcessing (wait for processing initial content)' failed."
There are differences in an on premise MS SQL server and Azure SQL Managed instance.
Refer to MS link which document these differences:
In this case, Using a server principal who only gets permissions thru role memberships is not supported by Microsoft (Azure)
> The following SQL Agent features currently aren't supported:
> * Proxies
> * Scheduling jobs on an idle CPU
> * Enabling or disabling an Agent
> * Alerts
This resulted in the Watchdog agent failing with the following error:
"The job failed. The owner (<Azure Account User>
We have tested this scenario and the installation of 1IM DB in Azure SQL Managed Instance completed successfully with this Installation user.