[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 94
  • Last Modified:

SQL Encryption question

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
isames
Asked:
isames
1 Solution
 
arnoldCommented:
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now