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:
- Open a creation wizard for a certificate. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - Certificates (SQL Server) - Properties.
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- 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. |