Microsoft® SQL Server 2012 Unleashed

Managing TDE in SSMS

You can also view and manage transparent data encryption in SQL Server Management Studio. To do so, right-click on the database in the Object Explorer for which you want to configure TDE and select Tasks; then select Manage Database Encryption. If you are setting up the initial configuration for TDE in a database, you see a dialog like that shown in Figure 18.2.

FIGURE 18.2 Enabling TDE in SSMS.

The options available in this dialog correspond to commands shown in Listing 18.1. You specify the encryption algorithm to be used and the server certificate used to protect the database encryption key. When you are ready to enable ...