Questions tagged [symmetric-key]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
38 views

What does a deterministic symmetric key mean?

In sqlservercentral blog I've encountered this phrase Symmetric keys are deterministic when created, meaning that the same parameters run in different databases will result in the same key. ...
5
votes
2answers
76 views

Changing a certifcate+key algorithm by dropping & recreating with the same names

We have a situation where a symmetric key has been created (a long time ago) using TRIPLE_DES. This is used to encrypt a password column, and is used by around ten stored procedures (that utilizes ...
5
votes
1answer
200 views

Can I control which algorithm SQL Server uses to hash symmetric key passphrases

I will start by describing the issue / cause before asking my question: If you are using a symmetric key in SQL to encrypt data. This can be set up as follows: CREATE MASTER KEY ENCRYPTION BY ...
1
vote
1answer
197 views

How to stop decrypting data after opening master key in SQL Server?

I have implemented data encryption using SQL Server symmetric key encryption technique using a certificate, master key with password. When we backup database from PROD server and restore to a ...
1
vote
1answer
41 views

What are implications for changing encryption from TRIPLE_DES to AES_128?

As title asks, what are implications for changing encryption from TRIPLE_DES to AES_128? I have an older database I've been tasked with hardening, and I need to updated the algorithm used for ...
1
vote
1answer
567 views

Recreate symmetric key of unknown CREATE SYMMETRIC KEY

I found that for each encryption of a symmetric key an entry in sys.key_encryptions is present and at least for ENCRYPTION BY CERTIFICATE-type entries I can use the certificate of the specified ...
0
votes
1answer
590 views

How can we decrypt data knowing the symmetric key used for the encryption?

In this article is explained how to decrypt a symmetric key. For example: SELECT SK.name, SK.symmetric_key_id, SK.key_length, SK.algorithm_desc, KE.crypt_type_desc, COALESCE(C.name,AK....
0
votes
1answer
328 views

How to protect a symmetric key?

When a symmetric key is created we have the option to encrypted it by using at least one of the following: certificate, password, symmetric key, asymmetric key or EKM. When a password is used, it it ...
4
votes
1answer
402 views

Where does SQL Server store symmetric keys?

I am wondering if symmetric keys created in particular database are being stored in the primary file group? Or they are stored in some special file group which the user is not able to interact with? ...
2
votes
1answer
338 views

Creating Symmetric Key from external provider

Knowing the security objects hierarchy, we can see that in order to create a Symmetric Key and encrypt data, we need to create: Database Master Key which is protected by password Certificate which is ...