Can't read principal id from SQL server after it has been created

[linak-lukasmendez]

I'm using Terraform to build and modify my infrastructure in Azure. One problem I have discovered is that when I create or modify an SQL Server it doesn't return a service principal id.

I recently made a bug in the AzureRM provider for Terraform as I though the issue was related to their code, but what I have been told is that the API call to /subscriptions/XXX/resourceGroups/rg-moc-global-weu-test-q7r8/providers/Microsoft.Sql/servers/sql-moc-global-weu-test-q7r8?api-version=2021-02-01-preview doesn't return the identity as it is supposed to.

Therefore we concluded that it might be an Azure API issue, and I've been asked to file an issue here for troubleshooting.

You can see the issue here

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @azureSQLGitHub.

Issue Details

---

I'm using Terraform to build and modify my infrastructure in Azure. One problem I have discovered is that when I create or modify an SQL Server it doesn't return a service principal id.

I recently made a bug in the AzureRM provider for Terraform as I though the issue was related to their code, but what I have been told is that the API call to /subscriptions/XXX/resourceGroups/rg-moc-global-weu-test-q7r8/providers/Microsoft.Sql/servers/sql-moc-global-weu-test-q7r8?api-version=2021-02-01-preview doesn't return the identity as it is supposed to.

Therefore we concluded that it might be an Azure API issue, and I've been asked to file an issue here for troubleshooting.

You can see the issue here

Author:	linak-lukasmendez
Assignees:	-
Labels:	question, SQL, Service Attention, customer-reported, needs-team-attention
Milestone:	-

[navba-MSFT]

Adding Service team to look into this.

@azureSQLGitHub Could you please look into this once you get a chance ? Thanks in advance.