There are 2 resource types available
azurerm_sql_server (Terraform Registry)
and
azurerm_mssql_server (Terraform Registry)
When I provision resource in Azure using above 2 resource types, I get similar resources in Azure. Also parameters and evrything is almost same in the above 2 resources.
Why why are they 2 separate resource names in Terraform ?
I had the same question and after a bit of search, it appeared that the azurerm_mssql_server is the newer version and azurerm_sql_server is not being updated. See this link - https://github.com/terraform-providers/terraform-provider-azurerm/issues/6502.
The azurerm_sql_server resource is deprecated in version 3.0 of the AzureRM provider and will be removed in version 4.0. Please use the azurerm_mssql_server resource instead.
Thank