Certificates Editor (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

The Certificates Editor lets you view and modify check certificate properties.

To edit a certificate

  1. Open an editor on the certificate. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


This tab lets you view all properties assigned when the certificate was created. For more information, see Certificates (SQL Server) - Properties. In addition, this tab lets you modify the following properties: Authorization Owner - the AUTHORIZATION argument. Active for Begin Dialog - the ON/OFF values for a ACTIVE FOR BEGIN_DIALOG = option. Change Encryption Mechanism - activates the Encryption Type control, letting you change the encryption method used for this certificate. Encryption Type - lets you select among encryption using the MASTER KEY, a USER_PASSWORD, or NONE. Encryption Password - available if you select an Encryption Type of USER_PASSWORD, it lets you provide the specific encryption password.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.