CODEWITHSUNDEEP
securitysql-server-expresstde
user627061
user627061

Reputation: 11

sql express 2008 & tde

Good afternoon,

Anyone know if sql express 2008 version, the option of using TDE (Transparent Data Encryption).

I tried using it for testing and the server gave me the following error.

"The transparent data encryption is not available in the publication of this instance of SQL Server. See Books Online for more details on feature support in different editions of SQL Server."

Thanks and a greeting.

Upvotes: 1

Views: 1235

Answers (2)

Neil Weicher
Neil Weicher

Reputation: 2502

As mentioned, Microsoft supports TDE only in Enterprise Edition. However, there are several third party products that will provide TDE to all editions and verions of SQL Server, including SQL Express. One of those products being ours: Encryptionizer for SQL Server. Another one that I am aware of is DBDefence. Internally they work very differently though: Encryptionizer sits between SQL Server and the Operating System, while DBDefence injects itself into the SQL process running in memory to change the behavior of the process.

Upvotes: 0

Lucero
Lucero

Reputation: 60190

TDE is available only in Enterprise editions AFAIK.

Upvotes: 3

Related Questions