Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server 2008 Property Editors › Define a Symmetric Key in SQL Server 2008 or 2012

Define a Symmetric Key in SQL Server 2008 or 2012

Use the SQL Server Symmetric Key Editor to define symmetric keys at the database level in a SQL Server 2008 or 2012 physical model.

To define a symmetric key in SQL Server 2008 or 2012

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

   The SQL Server Symmetric Key Editor opens.

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

   Note: Click New on the toolbar to create a new symmetric key. Use the Enter filter text box to filter a very large list of symmetric keys to quickly locate the one that you want to define.

   Name

   Displays the symmetric key name. You can change the symmetric key name in this field.

   Algorithm

   Specifies to use an algorithm for the symmetric key. Select an algorithm from the drop-down list.

   Authorization

   Specifies the owner of the symmetric key. Select a name from the drop-down list.

   Generate

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

3. Click the General tab and work with the following options:

   Using Certificates

   Specifies the certificates that will be part of the symmetric key. You can select one, multiple, or no certificates. Click the icon on the toolbar to open the SQL Server Certificate Editor to work with certificates.

   Using Asymmetric Keys

   Specifies the asymmetric keys that will be part of the symmetric key. You can select one, multiple, or no asymmetric keys. Click the icon on the toolbar to open the SQL Server Asymmetric Key Editor to work with asymmetric keys.

   Using Symmetric Keys

   Specifies another symmetric key to reference. You can select one, multiple, or no symmetric keys.

4. Click the Provider tab to specify provider key options.
5. Click the Permission tab to define the permissions for the symmetric key.
6. (Optional) Click the Comment tab and enter any comments that you want to associate with the symmetric key.
7. (Optional) Click the Where Used tab to view where the symmetric key is used in the model.
8. (Optional) Click the UDP tab to work with user-defined properties for the symmetric key.
9. (Optional) Click the Notes tab to view history information and view or edit user notes.
10. Click Close.

    The symmetric key is defined and the SQL Server Symmetric Key Editor closes.