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:

Is Vector Search in SQL Server 2025 the Key to Unlocking New Data Insights?

 The advent of AI has ushered in ground breaking changes in most areas of technology. AI is synonymous with a humongous amount of data, data...