Previous Topic: Define SQL Server 2008 FilesNext Topic: Define a SQL Server 2008 Full-Text Stoplist

Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server 2008 Property Editors › Define a SQL Server 2008 Database Encryption Key

Define a SQL Server 2008 Database Encryption Key

SQL Server 2008 and 2012 enable encryption of an entire database, data files, and log files, without the need for application changes. Encryption lets you meet the demands of regulatory compliance and overall concern for data privacy. Some of the benefits of transparent data encryption include searching encrypted data using both range and fuzzy searches, searching secure data from unauthorized users, and data encryption. These can all be enabled without changing existing applications.

Use the SQL Server Database Encryption Key Editor in a SQL Server 2008 or 2012 physical model to define the encryption key to use for transparently encrypting a database.

To define a SQL Server database encryption key

  1. Click Target - SQL Server, Security, Database Encryption Keys on the Model menu.

    The SQL Server Database Encryption Key Editor opens.

  2. Select the database encryption key in the Navigation Grid that you want to define and work with the following options:

    Note: Click New New icon in property editors to create a new object on the toolbar to create a new database encryption key. Use the Enter filter text box to filter a very large list of database encryption keys to quickly locate the one that you want to define.

    Name

    Specifies the name of the database encryption key. You can change the name of the database encryption key in this field.

    Database

    Specifies the database for which the encryption key applies.

    Algorithm

    Specifies the encryption algorithm used to encrypt the database encryption key.

    Certificate

    Specifies the name of the encryptor used to encrypt the database encryption key.

    Asymmetric Key

    Specifies the encryption algorithm used to encrypt the database encryption key.

    Generate

    Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

  3. (Optional) Click the Comment tab and enter any comments that you want to associate with the database encryption key.
  4. (Optional) Click the UDP tab to work with user-defined properties for the database encryption key.
  5. (Optional) Click the Notes tab to view history information and view or edit user notes.
  6. Click Close.

    The database encryption key is defined and the SQL Server Database Encryption Key Editor closes.