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:

SQL Server 2025 ready to go

 I have not yet done looking at SQL Server 2022, SQL Server 2025 is ready to go. Microsoft is indeed relentless!  Microsoft announced SQL Se...