Azure / Azure/azure-rest-api-specs

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

Open
#23,249 2 comments 0 reactions 0 assignees View on GitHub
customer-reported needs-team-attention question Service Attention SQL
Dominant language
TypeSpec
Stars
3.1k
Forks
5.9k
Avg merge
3d 37m
Merged PRs (30d)
446

Description

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](https://github.com/hashicorp/terraform-provider-azurerm) 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](https://github.com/hashicorp/terraform-provider-azurerm/issues/20767)

Contributor guide

Open the contributing guide

Research direction

Start with the Azure SQL Servers endpoint and API version in the issue, then compare its create or update response with the behavior reported in the linked Terraform provider issue. Trace whether the service principal identity is absent from the response, and use that comparison to establish the expected API behavior before deciding what specification change is needed.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, sql
Domain
api, cloud, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.