Monday, July 13, 2015

What is needed to encrypt a database in SQL Server 2016 CTP 2.1?

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 Enccryption 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:

TestEncryptOptions3.png

No comments: