Asymmetric Keys Wizard (SQL Server)
Go Up to Microsoft SQL Server Object Wizards
This wizard lets you build and submit a CREATE ASYMMETRIC KEY statement with options corresponding to the contained private and public keys.
To create a new asymmetric key using a wizard:
- Open a creation wizard for an asymmetric key. 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 - Asymmetric Keys (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.
Asymmetric Keys (SQL Server) - Properties
When creating or editing an asymmetric key, this tab/panel lets you work with the following settings:
Setting | Availability and description | |
---|---|---|
Authorization Owner |
The name of the user that will own the certificate. | |
Name |
The name for the certificate. | |
Use Existing Keys |
Selected, a WITH ALGORITHM option variation of the CREATE ASYMMETRIC KEY statement is generated. Deselected, a FROM FILE, FROM EXECUTABLE FILE, FROM ASSEMBLY, or FROM PROVIDER option variation of the CREATE ASYMMETRIC KEY statement is generated. | |
Provider Name |
Available if Use Existing Keys is not selected. |
Lets you provide a FROM PROVIDER argument value, specifying an Extensible Key Management provider and name. |
Key Algorithm |
Available if Use Existing Keys is not selected. |
Lets you select a WITH ALGORITHM value of RSA_512, RSA_1024, or RSA_2048, specifying the key length. |
Key Name In Provider |
Available if Use Existing Keys is not selected, after Provider Name is entered. |
Lets you provide a PROVIDER_KEY_NAME value, specifying the key name from the external provider. |
Creation Disposition |
Lets you select a CREATION_DISPOSITION value of OPEN_EXISTING or CREATE_NEW, specifying whether the asymmetric key is mapped to an existing EKM key or a new key is created on the EKM device. | |
File |
Available if Use Existing Keys is selected. |
Let you provide FROM FILE, FROM EXECUTABLE FILE, FROM ASSEMBLY, or FROM PROVIDER option values, respectively. |
Executable File | ||
Assembly | ||
Provider Name | ||
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. |