SQL 2016 Standard Edition SP1 TDE Issue

Question

Post reply

SQL 2016 Standard Edition SP1 TDE Issue

jeffhome43

SSC Veteran

Points: 206
More actions
January 24, 2018 at 2:30 am

#328255

Long shot I know, but kind of losing the will to live with this now.
Have created a new instance o0f SQL 2016, it is fully patched and is showing as SP1, trying to make a brand new database TDE compliant, but getting the error below,
'Transparent Data Encryption is not available in the edition of this SQL Server instance'
When trying to run
CREATE
DATABASE ENCRYPTION KEY
WITH ALGORITHM = AES_128
ENCRYPTION BY SERVER CERTIFICATE CertificateName;
From all the reading I have done in the last day or so I have.net framework 4.6 installed and well as ODBC 13 for Sql, which seem to be what is required to get this working,
Anybody help with getting past this? any help would be appreciated

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

NorthernSoul SSCertifiable Points: 6869 More actions · Answer 1

What edition are you running? You can run the following to find out.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Thanks

jeffhome43 SSC Veteran Points: 206 More actions · Answer 2

NorthernSoul - Wednesday, January 24, 2018 2:54 AM
What edition are you running? You can run the following to find out.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Thanks

I am running Standard Edition SP1, which according to the Sp1 details, now includes the ability to use TDE

Thom A SSC Guru Points: 99135 More actions · Answer 3

The error message is quite clear here: "Transparent Data Encryption is not available in the the edition of this SQL Server instance." Emphasis mine.

As per the Supported Features page of SQL Server 2016 (https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016), TDE is only available in Enterprise Edition. You are using Standard.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

NorthernSoul SSCertifiable Points: 6869 More actions · Answer 4

Sorry, I've just seen you said it was standard edition. I'm pretty sure TDE is not available in standard edition. When I have a few minutes spare I'll double check this.

Thanks

Thom A SSC Guru Points: 99135 More actions · Answer 5

jeffhome43 - Wednesday, January 24, 2018 2:55 AM
NorthernSoul - Wednesday, January 24, 2018 2:54 AM
What edition are you running? You can run the following to find out.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Thanks
I am running Standard Edition SP1, which according to the Sp1 details, now includes the ability to use TDE

TDE was not one of the features added/unlocked with 2016 SP1 to Standard Edition. You may be thinking of Always Encrypted,

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

jeffhome43 SSC Veteran Points: 206 More actions · Answer 6

Ok, thanks, then it is my mis-understanding of all the reading I have done over the last day or so, think I must have read Always encrypted as TDE.

Thanks all the responses.

NetLibSecurity Old Hand Points: 318 More actions · Answer 7

I don't know if you are interested in considering third party solutions, but there are two that provide TDE to all editions of SQL Server, from Express to Enterprise. One is Encryptionizer for SQL Server and the other is DBDefense. Although the work very differently: Encryptionizer sits between SQL Server and the OS, while DBDefense injects code into the running SQL process. (Disclaimer: I am with NetLib Security https://netlibsecurity.com/)