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:

What is SQLOISIM? What is it used for in SQL Server?

SQLIOSIM is a tool for simulating SQL Server IO. SQLIOSIM performs reliability and integrity tests on the disk systems that SQL Server uti...