Encrypt SQL express 2005 database

Posted on 2007-08-07
Last Modified: 2013-11-05
Is it possible to encrypt the entire SQL Express database or do i have to encrypt the data in certain fields? Links and good documentation would be a great help.
Question by:ronayers
    LVL 42

    Accepted Solution

    I don't know about 3rd party products, but with native SQL Server encryption is at the column level.
    LVL 8

    Assisted Solution

    You can always code your own encryption before you save data back to the tables.

    As for encrypting the entire database, SQL Server Express supports it:

    Here is a good walkthrough of column level encryption:

    Expert Comment

    Just a quick note to DaveCorun: if you look carefully at the link you've provided, SQL Server Express DOESN'T support encryption of the entire database - under SQL Server 2008, only the Enterprise Edition includes 'TDE', all lower editions offer only column-by-column encryption...

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    733 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now