– Enable AAD auth on Azure SQL server
– Conn to Azure SQL database via AAD admin
– Create contained user for the managed identity (using Azure VM name as contained username)
create user <vmname> from external provider;
alter role db_owner add member <vmname>;
Read on for the full set of steps.