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 ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
