question

deepal avatar image
deepal asked

while encrypting i got this error how can i solve it???

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.
encryptioneditionseditencryptededition
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
You have several answers below. For each of those answers that are helpful you should click on the thumbs up next to the answers so that it turns green. If any one of the answers below lead to a solution to your problem, click on the check mark next to that one answer so that it turns green. This web site works best if you do the voting and marking of answers so that the next person who looks at your question knows what the solution was.
0 Likes 0 ·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
It means what it says. You are using an edition of SQL Server which doesn't support Transparent Data Encryption, and therefore you can't use it. TDE is supported in Developer edition and Enterprise edition. Use this Query to find out which edition you are running: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
If you look in the Security section of the feature comparison of different editions of SQL Server, you'll see that TDE (Transparent Data Encryption) is an Enterprise-edition thing. [SQL Server 2014 - Feature Comparison - Security features][1] If you're using a different version of SQL Server, there's a dropdown box at the top of that page to allow you to switch between SQL 2008/2008R2/2012/2014. If you're using SQL 2016, then [there's a different link to the edition feature comparison list][2]. NB: Magnus said that it's also a feature available in the Developer edition of SQL Server - which it is. The Developer edition is a full-feature-but-cheap edition that's for use by developers to allow them to, erm, develop their application using the full feature set. It is *not* for use in a production environment. [1]: https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx#Enterprise_security [2]: https://msdn.microsoft.com/en-us/library/cc645993.aspx#Enterprise_security
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.