Azure / Azure/azure-rest-api-specs

Azure SQL Server: Server External Administrator has incorrect mutability

Open
#22,464 4 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
2d 22h
Merged PRs (30d)
444

Description

The [spec for Microsoft.Sql/servers](https://github.com/Azure/azure-rest-api-specs/blob/main/specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/Servers.json#L971-L978) lists `read` and `create` under `x-ms-mutability`.
Assigning an Azure AD administrator is possible through [Azure PowerShell](https://github.com/Azure/azure-powershell/blob/main/src/Sql/Sql/ServerActiveDirectoryAdministrator/Cmdlet/SetAzureSqlServerActiveDirectoryAdministrator.cs) and the Azure Portal without re-creating the resource.

Contributor guide

Open the contributing guide

Research direction

Start at specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/Servers.json near lines 971-978 and inspect the Microsoft.Sql/servers external administrator property and its x-ms-mutability values. Use the linked Azure PowerShell cmdlet and Portal behavior as context; done means the specification reflects that the administrator can be changed without recreating the server.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, openapi, powershell
Domain
api
Issue type
Bug
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
48/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.