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

1. Open a creation wizard for an asymmetric key. 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 Asymmetric Keys (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.

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.