azurerm_mssql_database "Error: serverless databases do not support license type"

[waynejnicklin]

Is there an existing issue for this?

• [X] I have searched the existing issues

Community Note

• Please vote on this issue by adding a :thumbsup: reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, 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

Terraform Version

0.15.3

AzureRM Provider Version

2.99.0

Affected Resource(s)/Data Source(s)

azurerm_mssql_database

Terraform Configuration Files

resource "azurerm_mssql_database" "example" {
  name                        = "example"
  server_id                   = azurerm_mssql_server.sql_server.id
  sku_name                    = "GP_S_Gen5_1"
  collation                   = "SQL_Latin1_General_CP1_CI_AS" 
  storage_account_type        = "LRS"
  min_capacity                = 1
  auto_pause_delay_in_minutes = 60

Since upgrading to 2.99.0, we are getting the error "serverless databases do not support license type".

I've tried setting the license_type explicitly to null, but still the error occurs.

Debug Output/Panic Output

│ Error: serverless databases do not support license type
│ 
│   with azurerm_mssql_database.example,
│   on sql_db_datamart.tf line 1, in resource "azurerm_mssql_database" "example":
│    1: resource "azurerm_mssql_database" "example" {
│ 
╵
##[error]Error: The process '/workspace/_tool/terraform/0.15.3/x64/terraform' failed with exit code 1

Expected Behaviour

No response

Actual Behaviour

No response

Steps to Reproduce

No response

Important Factoids

No response

References

No response

[waynejnicklin]

For info, I just upgraded to AzureRM 3.1.0... same issue.

[waynejnicklin]

Also the plan file doesn't show any change to the license type, just this (expected) change:

  ~ min_capacity                        = 1 -> 0.5

[waynejnicklin]

Seems to be resolved by upgrading to latest TF version

[github-actions[bot]]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues. If you have found a problem that seems similar to this, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.