Solved

SQL Encryption question

Posted on 2016-09-28
2
69 Views
Last Modified: 2016-09-29
Can anyone explain the difference between encryptbykey, encryption, encryptbypassphrase, and encryptbycert?

I basically want to know when is it ideal to use one method versus the other.
0
Comment
Question by:isames
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 78

Accepted Solution

by:
arnold earned 500 total points
ID: 41820866
Just for the reference:

by Key
https://msdn.microsoft.com/en-us/library/ms174361.aspx

By passphrase
https://msdn.microsoft.com/en-us/library/ms190357.aspx
By cert
https://msdn.microsoft.com/en-us/library/ms188061.aspx

The key is info in the sql server.
The passphrase uses external INPUT.

You can also use cert based encryption.

You can encrypt the whole database. You can encrypt individual columns

Most deals with who controls access to the parameters as well as DR backup of references used for encryption......

I.e when the app uses passphrase, the app has to maintain the information use to encrypt to decrypt.

It might be a consideration for the setup/DR plans/backup plans..

Presumably if you are engaging in encrypting data with either, you should make sure your SQL connection forces encryption since all of these transmit the data in clear text.

You could encrypt data within the APP inserting encrypted data...
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Running total between 2 sql tables in Sql 6 50
EF5 How do I stop pre-compiled views? 8 54
Replace statements HTML with HTML IF 8 66
mssql 7 32
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

751 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