Support for enabling azure ad authentication on azurerm_mssql_virtual_machine

[nathanblair]

Is there an existing issue for this?

• I have searched the existing issues

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave comments along the lines of "+1", "me too" or "any updates", they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment and review the contribution guide to help.

Description

Unfortunately the previous issue for this was closed and locked so now a new issue needs opened to track progress on this.

The previous issue was closed and it was stated that AZ REST API did not have a way to configure the AD block for MSSQL VM. As of now, it looks like that may be available as the AzAPI template does have that block configured and Microsoft even has it in their AzAPI provider documentation here:

https://learn.microsoft.com/en-us/azure/templates/microsoft.sqlvirtualmachine/sqlvirtualmachines?pivots=deployment-language-terraform

https://learn.microsoft.com/en-us/azure/templates/microsoft.sqlvirtualmachine/sqlvirtualmachines?pivots=deployment-language-terraform#aadauthenticationsettings-2

New or Affected Resource(s)/Data Source(s)

azurerm_mssql_virtual_machine

Potential Terraform Configuration

resource "azurerm_mssql_virtual_machine" "vms" {
    ...
    azure_ad_authentication { # Eventually would become "entra_id_authentication"?
        client_id = "string"
    }
    ...
}

References

#22904