Security Center says to enable Transparent Data Encryption for SQL DBs... but it's already on?

Matthias Cermak 1 Reputation point

Hey there!

I am reviewing the Security Center of an Azure subscription, but I noticed that it's recommending that I turn on Transparent Data Encryption for two databases that already had Transparent Data Encryption enabled - and reviewing the settings shows that it very much still IS enabled, and in fact had been for months. This alert is "new" tho, only started showing up for me three days ago.

For one of the databases, I already tried to disable and reenable Transparent Data Encryption three days ago, and it didn't help.

Is this a bug or is there anything I can do, aside from ignoring it?

EDIT: This issue persisted until last Friday (July 16th), but today (July 19th) it seems to be gone. So, given I didn't change anything in the meantime... I'm gonna say temporary bug.

Azure SQL Database
Microsoft Defender for Cloud
Microsoft Defender for Cloud
An Azure service that provides threat protection for workloads running in Azure, on-premises, and in other clouds. Previously known as Azure Security Center and Azure Defender.
980 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 31,456 Reputation points MVP

    This recommendation usually comes with a Quick Fix option, that helps you "turn on" the data encryption on the unhealthy resources in a single-click. Could you try that option to see if that eradicate the issue?

    Try also this PowerShell script.

    1 person found this answer helpful.