Physical Modeling › SQL Server Physical Property Editors › SQL Server Database Objects › SQL Server Security › Define SQL Server Certificates

Define SQL Server Certificates

Use the SQL Server Certificate Editor to define the attributes for a security key in a SQL Server 2005/2008 physical model.

To define SQL Server certificates

1. Click Security, Certificates on the Database menu.

   The SQL Server Certificate Editor opens.

2. Select the certificate 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 certificate.

   • Name

     Displays the certificate name. You can change the certificate name in this field.

   • Authorization

     Specifies the name of the user that owns the certificate. Select a name from the drop-down list.

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

     Specifies the assembly to use. Select an assembly from the drop-down list.

     Note: Click New to open the SQL Server Assembly Editor to add a new assembly.

   • Executable File

     Specifies an executable name property to indicate the complete path to a DER-encoded file that contains the certificate.

     Note: Click New to open the SQL Server File Editor to add a new executable file type.

   • Is Private Key

     Specifies to use the private key of the certificate, if the certificate is being created from a file.

   • Private Key File

     Specifies the private key file path.

   • Certificate Subject

     Defines text that refers to a field in the metadata of the certificate as defined in the X.509 standard.

   • Start Date

     Defines the start date of when the certificate becomes valid.

   • Expiration Date

     Defines the certificate expiration date.

   • Active for Begin Dialog

     Specifies to make the certificate available to the initiator of a Service Broker dialog conversation.

4. Click the Permission tab to define the permissions for the certificate.
5. (Optional) Click the Comment tab and enter any comments that you want to associate with the certificate.
6. (Optional) Click the UDP tab to work with user-defined properties for the certificate.
7. Click Close.

   The certificate is defined and the SQL Server Certificate Editor closes.