Use the SQL Server Certificate Editor to define the attributes for a security key in a SQL Server 2012 physical model.
To define a SQL Server 2012 certificate
A new certificate appears with a default name.
The SQL Server Certificate Editor opens.
Note: Click New on the toolbar to create a certificate. Use the Enter filter text box to filter a large list of certificates to locate the one that you want to define.
Displays the certificate name. You can change the certificate name in this field.
Specifies the name of the user that owns the certificate. Select a name from the drop-down list.
Specifies the database to which the certificate is attached.
Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.
Defines text that refers to a field in the metadata of the certificate as defined in the X.509 standard.
Defines the start date of when the certificate becomes valid.
Defines the certificate expiration date.
Specifies to make the certificate available to the initiator of a Service Broker dialog conversation.
Specifies whether you want to use the private key of the certificate. Specify this value only if you want to create the certificate from a file.
Specifies the assembly to use. Select an assembly from the drop-down list.
Note: Click New to open the SQL Server Assembly Editor to add an assembly.
Specifies an executable name property to indicate the complete path to a DER-encoded file that contains the certificate.
Note: Click New to open the SQL Server File Editor to add a new executable file type.
Specifies the private key file path.
Note: Click New to open the SQL Server File Editor to add a file type.
Specifies the certificate in the binary format. If the certificate has a private key, the binary must not include the private key. Convert the certificate from binary to hexadecimal and enter the hexadecimal number in this field.
Specifies the private key of the certificate in the binary format. Convert the private key from binary to hexadecimal and enter the hexadecimal number in this field.
The certificate is defined and the SQL Server Certificate Editor closes.
Copyright © 2013 CA.
All rights reserved.
|
|