Can SQL server 2017 Standard Edition use Transparent Data Encryption (TDE)

Question

When we used SQL server to configure transparent data encryption, the following error occurred: "Transparent data encryption is not available in SQL server instances of this version category." The SQL server version we used is 2017 Standard Edition. Can we use transparent data encryption in this version

Answer 1

Hi @唐明宇,

As stated in Microsoft on-line documentation, TDE is explicitly available only in Enterprise edition.

The matrix in https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017?view=sql-server-2017 is unambiguous.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

The SQL server version we used is 2017 Standard Edition. Can we use transparent data encryption in this version>

Transparent database encryption is included in Standard Edition in SQL Server 2019 and later versions but not in SQL Server 2017 and earlier. The SQL 2017 RDBMS security topic shows TDE is not available with Standard Edition.