Certificate Wizard (SQL Server)

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:
   • Properties panel. For more information, see Certificates (SQL Server) - Properties.
   • DDL View panel. For details, see Previewing the DDL Generated to Create the New Object.
3. Click Execute 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.