Solved

SQL Database Encryption

Posted on 2015-02-10
4
78 Views
Last Modified: 2015-02-18
We have SQL 2005 and 2008 and wondered whether it's possible to encrypt the data in the database and if so, how is this achieved?
0
Comment
Question by:Hypervizor
  • 2
4 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 40602583
this is possible, using the built-in encryption functionality;
search for "sql 2005 encryption" and you will find plenty of pages about this.
0
 
LVL 10

Accepted Solution

by:
HuaMinChen earned 500 total points
ID: 40602620
0
 
LVL 10

Expert Comment

by:HuaMinChen
ID: 40602622
Read the attached
TDEandEFSBitLocker.docx
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40613696
Hypervizor, do you need more help on this or the answers you got are enough? If so, please accept one as solution.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Generate Scripts Fails 5 36
Run SQL Server Proc from Access 11 31
T-SQL: Do I need CLUSTERED here? 13 44
SQL Error - Query 6 26
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
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…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

777 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