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

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

Define a SQL Server Database Encryption Key

SQL Server 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 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
  3. Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.
  4. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
  5. (Optional) Click the UDP tab to work with user-defined properties for the object.
  6. (Optional) Click the Notes tab to view and edit user notes.
  7. Click Close.

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