Asymmetric Keys 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 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:
  3. 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.