Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
Encryption on database tables MSSQL 2008
DO you have any tutorial, suggestions on how to encrypt tables on database MSSQL 2008?
Once they are encrypted, would it affect my ASP.net applications I have when i call such tables?
Microsoft SQL Server
8/22/2022 - Mon
Depends on how you want to encrypt.
If you are interested in at-rest encryption, then you can simply encrypt the storage media (bitlocker, efs, whatever)
If you want to do explicit encryption, then you need to alter apps to use the 2008 crypto primitives (such as
- that means coding changes.
if you want to do this without altering the code, then you need to follow
to Transparent Data Encryption - might take a couple of looks before you get the idea, so feel free to post follow up questions in this thread for clarification :)
Hi thank you for the info.
I was interested for encryption at rest and in transit, when data is moving.
Without altering the code would be great. Is the transparent data encryption used when data is in transit?
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today
7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent