Certificate Wizard (SQL Server)

From RapidSQL
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Wizards

This wizard lets you build and submit a CREATE CERTIFICATE statement, adding a certificate to a database.

To create a new certificate using a wizard:

  1. Open a creation wizard for a certificate. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

Certificates (SQL Server) - Properties

When creating or editing a certificate, this tab/panel lets you work with the following settings:

Setting Availability and description

Owner

The name of the user that will own the certificate.

Name

The name for the certificate.

Use Existing Keys

Lets you choose between EXISTING KEYS and GENERATE NEW KEYS options.

Active For Begin Dialog

Lets you select ON/OFF values for a ACTIVE FOR BEGIN_DIALOG = option.

Subject

Available if Use Existing Keys is not selected.

Lets you provide a WITH SUBJECT = clause value, referring to a field in the certificate metadata.

StartDate and ExpiryDate

Available if Use Existing Keys is not selected and after Subject is provided.

Lets you provide START_DATE = and EXPIRY_DATE = values, defining the period that the certificate is valid

Assembly

Available if Use Existing Keys is selected.

These controls let you select among FROM ASSEMBLY =, FROM FILE =, FROM EXECUTABLE FILE = clauses and provide the relevant signed assembly, path to a DER-encoded certificate file, or path to a private key file.

ExecutableFile

File

PrivateKeyFile

Available if Use Existing Keys is selected.

Lets you provide a WITH PRIVATE KEY (FILE =... clause value, specifying that the certificate’s private key is loaded.

Encryption Password

Available if Use Existing Keys is not selected and after Subject is provided.

Lets you provide an ENCRYPTION BY PASSWORD = clause value, specifying the password used to encrypt the private key.

DecryptionPassword

Available if Use Existing Keys is not selected. Also available if Use Existing Keys is selected and after an Assembly or PrivateKeyFile value is provided.

Lets you provide a DECRYPTION BY PASSWORD = clause value, specifying the password used to decrypt a private key retrieved from file.