Share via

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

Matthias Cermak 1 Reputation point
2021-07-16T12:59:16.293+00:00

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.
1,386 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 33,946 Reputation points MVP
    2021-07-16T20:56:26.053+00:00

    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.