Database Encryption in SQL Server 2008 Enterprise Edition
SQL Server Technical Article
Writers: Sung Hsueh
Technical Reviewers: Raul Garcia, Sameer Tejani, Chas Jeffries, Douglas MacIver, Byron Hynes, Ruslan Ovechkin, Laurentiu Cristofor, Rick Byham, Sethu Kalavakur
Published: February 2008
TDE does not replace cell-level encryption, EFS, or BitLocker. This white paper compares TDE with these other encryption methods for application developers and database administrators. While this is not a technical, in-depth review of TDE, technical implementations are explored and a familiarity with concepts such as virtual log files and the buffer pool are assumed. The user is assumed to be familiar with cell-level encryption and cryptography in general. Implementing database encryption is covered, but not the rationale for encrypting a database.
Read Database Encryption in SQL Server 2008 Enterprise Edition
Abstract courtesy : Microsoft
Reference: Pinal Dave (https://blog.sqlauthority.com)
1 Comment. Leave new
Hi Pinal
USE master;
GO
CREATE MASTER KEY ENCRYPTION BY PASSWORD = ”;
go
CREATE CERTIFICATE MyServerCert WITH SUBJECT = ‘My DEK Certificate’;
use DbName
go
CREATE DATABASE ENCRYPTION KEY
WITH ALGORITHM = AES_256
ENCRYPTION BY SERVER CERTIFICATE MyServerCert;
I am getting below Error Please suggest:
Cannot find the certificate ‘MyServerCert’, because it does not exist or you do not have permission.
Note : Cerificate are there on named ‘MyServerCert’
Server Configuration :
Window Server : 2003 SP2
SQL Server 2008 Cluster with Enterprise Edition SP1
Regards
Jayant Dass