?
Solved

Encryption In SQL Server 2008 R2

Posted on 2011-05-11
2
Medium Priority
?
572 Views
Last Modified: 2012-05-11
I was looking at TDE in SQL Server 2008 R2. I see that it is in Enterprise Edition. Is it in Standard Edition? If not, what Encryption options are there in Standard Edition?
0
Comment
Question by:GoCubs
2 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 2000 total points
ID: 35740647
TDE is not available in Standard Editions of SQL Server.
In Standard edition, Column level encryption is available.
More info on how to set it up here:
http://blogs.msdn.com/b/lcris/archive/2005/06/10/sql-server-2005-column-encryption-demo-part-2.aspx
0
 

Author Comment

by:GoCubs
ID: 35740797
Thanks I'll check that out.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question