?
Solved

SQL Database Encryption

Posted on 2015-02-10
4
Medium Priority
?
94 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 143

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 11

Accepted Solution

by:
HuaMinChen earned 2000 total points
ID: 40602620
0
 
LVL 11

Expert Comment

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

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

594 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