Encryption SQL server 2008 R2 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Encryption SQL server 2008 R2

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2010-08-27 : 06:49:29

Dear all,

I am newbie to SQL Server 2008 and i need help related to Encyption Techniques in SQL server 2008.

Just for your reference..our databases are being migrated to SQL server 2008 R2

Ple help me from where i need to start.

Thanks,
Gangadhar

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-27 : 13:26:06

I'd start here: http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=sql+server+2008+encryption

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2010-09-07 : 00:02:05

Hi Tara,

I started with MSDN and learned some of the things for Encryption,
I ran the following query to get prepare for Encryption in SQL 2008

USE master;
GO
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'ObyGoxDandy2974728';
GO
CREATE CERTIFICATE PersDBCert WITH SUBJECT = 'Certificate for
Personnel DB'
GO
USE Personnel
GO
CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = TRIPLE_DES_3KEY
ENCRYPTION BY SERVER CERTIFICATE PersDBCert
GO
ALTER DATABASE Personnel
SET ENCRYPTION ON
GO

To manage the encryption state of the database by using SQL Server Management
Studio, follow these steps:
1. In the Object Explorer view in SQL Server Management Studio, right-click the database you want to configure, and then select Properties from the shortcut menu.
2. In the Database Properties dialog box, select Options from the Select A Page list. You can now do the following:
Turn on database encryption by setting Encryption Enabled to True.

And and after that i have created one sample table and inserted some data.
And selected by using select * from tablename

Still i am able to view the original data its not encrypted ?

Any help in this regard highly helpful

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources