Failover group issue

Question

Hello team,

I am getting below Error while adding SQL MI in failover group.

The gateway did not receive a response from 'Microsoft.Sql' within the specified time period.

Answer 1

Based on this old thread on SOF :

• Try removing the azurerm_mssql_database_extended_auditing_policy try replacing with the old extended_auditing_policy block within azurerm_mssql_database .
• Using storage requires to enable 'Allow trusted Microsoft services to access this storage account' on the storage account.
• Make sure you have Storage Blob Data Contributor for the storage created from terraform.
• Enable System Managed Identity on the existing SQL Server.
• For the workaround, try editing the state file to remove the "status": "tainted", line from the "azurerm_mssql_server" resource.

For more in detail, please refer below links:

azure - Creating SQL Server vulnerability assessment resource using a private Storage Account fails - Stack Overflow.

mssql_server: breaking change in the azure api · Issue #8915 · hashicorp/terraform-provider-azurerm · GitHub.

Export database fails with "The gateway did not receive a response from 'Microsoft.Sql'" - Microsoft Q&A.