EMS logo

Produkt Navigation

SQL Manager for SQL Server

Unsere Partnerschaften

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

Online Bedienungsanleitung

Asymmetric Keys

In SQL Server 2005 and higher, data can be encrypted with a hierarchical encryption and key management infrastructure. Each layer encrypts the layer below it by using a combination of the following mechanisms for encryption: symmetric keys, asymmetric keys, certificates.


An Asymmetric key is composed of a private key and the corresponding public key. Each key can decrypt data encrypted by the other. Asymmetric encryption and decryption provide a higher level of security than symmetric encryption. An asymmetric key can be used to encrypt a symmetric key for storage in a database.



Asymmetric Key Editor allows you to define asymmetric key properties. It opens automatically when you create a new asymmetric key and is available on editing an existing one.


To open an asymmetric key in Asymmetric Key Editor, double-click it in the DB Explorer tree.