Hello Team, I am facing one issue when deploying Azure SQL MI from Terraform.
I need to enable both Authentication (SQL and Entra) and set a group as an Entra Admin. However, when I try to do that, I get error message as Server identity does not have Azure Active directory readers permissions. I am creating Service Principal for SQL MI. This is being run through Azure Devops pipeline, and the Service principal has “Contributor” and “Directory Reader” permissions at subscription level. Any help on this please, i have tried all possible ways but this just isnt working. Thank You