Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Let me start by saying that the instance of SQL Server 2012 I am attempting to set up TDE (Transparent Data Encryption) on, is the Enterprise edition.

However, when following the MSDN tutorial tutorial, I get to the following line:

create database encryption key with algorithm = AES_256 encryption by server certificate TDECertificate

and I get the error:

Msg 33117, Level 16, State 1, Line 6
Transparent Data Encryption is not available in the edition of this SQL Server instance. See books online for more details on feature support in different SQL Server editions.

Can anybody advise me as to why I would be getting this error?

share|improve this question
1  
What's the output of running SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') on your instance? –  Chris McKeown Sep 12 '12 at 13:35
    
+1 because that query would have lead me to see that I was in error. Thanks for the comment. –  bobble14988 Sep 12 '12 at 13:45
1  
Good to hear. I'll put that as an answer if you wouldn't mind accepting it :-) –  Chris McKeown Sep 12 '12 at 13:46
    
Of course, no problem. Thanks again. –  bobble14988 Sep 12 '12 at 14:52

2 Answers 2

up vote 3 down vote accepted

I've tried the same on my 2012 Developer instance and had no problems.

Ensure that the instance you're connected to is indeed Enterprise or Developer edition by running

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

share|improve this answer

Found the problem. It was between the chair and the keyboard.

We have two instances of SQL Server installed and I was querying the wrong one.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.