Tuesday, July 14, 2015

Before you encrypt a database

In order to enable encryption for a database you should set the encryption key.

Here is a database (TestEncrypt with three simple columns) which needs to be encrypted and for which no Encryption key is set.


TestEncryptOptions.png

Change Encryption Enabled from False to True by clicking on the handle.

TestEncryptOptions2.png
Click OK.
You get the following error message:

1 comment:

Do you know what you installed while custom installing SQL Server 2022?

 When you install any software in Windows OS, the key information gets into the Registry and some of which you can look up in the control pa...