Azure Synapse - SQL Pool with TDE - Deployment Fails

Question

Hi folks,

I try to provision a new SQL Dedicated Pool with TDE Settings enabled.

resource dedicatedSqlPool 'Microsoft.Synapse/workspaces/sqlPools@2021-06-01' = if(params.synapse.dedicatedSQLPool.enabled) {
  name: '${params.synapse.name}/${params.synapse.dedicatedSQLPool.name}'
  location: params.location
  tags: params.tags
  sku: params.synapse.dedicatedSQLPool.sku
  properties: {
    collation: params.synapse.dedicatedSQLPool.collation
    createMode: 'Default'
  }
}

resource tde 'Microsoft.Synapse/workspaces/sqlPools/transparentDataEncryption@2021-06-01' = {
  name: 'current'
  parent: dedicatedSqlPool
  properties: {
    status: 'Enabled'
  }
}

The Microsoft.Synapse/workspaces/sqlPools/transparentDataEncryption resource fails to deploy with the following error:

{
    "status": "Failed",
    "error": {
        "code": "40627",
        "message": "Operation on server '*****synapse name*****' and database '****database name***' is in progress.  Please wait a few minutes before trying again.",
        "details": [
            {
                "code": "40627",
                "message": "Operation on server '*****synapse name*****' and database '****database name***' is in progress.  Please wait a few minutes before trying again."
            }
        ]
    }
}

Does anyone had a similar issue and knows how to resolve it?

When I try to redeploy it, it works. So it seems like some operations are triggered after the sql pool was provisioned?

Answer 1

When deploying and setting TDE on the instance, you need to give a wait between the deploy and when you set it (usually if I am doing it in a PS command it'll be a 2-4 min wait before hitting any TDE setting as the db bounces when you apply it - or you need to set it when you deploy it using the parameter.

I have noticed this failure on the portal as well when the process can take longer than normal - or flag as a failure but then the pause/resume resolves and the TDE has been applied correctly.