select * from sys.databases where is_master_key_encrypted_by_server=1 select * from sys.certificates select * from sys.dm_database_encryption_keys where encryption_state=3 SELECT * FROM sys.symmetric_keys SELECT * FROM sys.asymmetric_keys  

Continuation from http://sqlcontent.com/index.php/category/sql-server-encryption/ Asymmetric Keys Encrypt by Password  do not require to have master key in the database. The following example creates an asymmetric key named _rsa_customer_accmaster_key by using the RSA_2048 algorithm, and protects the private key with a password. USE RSASecData GO CREATE ASYMMETRIC KEY _rsa_customer_accmaster_key WITH ALGORITHM = RSA_2048 ENCRYPTION BY PASSWORD = ‘G%$D@3@f5-34+!DF’; GO […]

[BOL]:Public Key Cryptography (PKI) is a form of message secrecy in which a user creates a public key and a private key. The private key is kept secret, whereas the public key can be distributed to others. Although the keys are mathematically related, the private key cannot be easily derived by using the public key. […]

  DBA struggles a lot to justify an Auditor that SQL Server Connections are encrypted. To prove the same I use my favorite tool Net Monitor to justify the same, but how SQL Server Encrypt it. SQL Server always encrypts network packets associated with logging in. If no certificate has been provisioned on the server […]