MSSQL Database Encryption in OpManager

Database Master Key is a symmetric key that is unique to each database in the SQL server instance. Database master keys are protected by the Service Master Key. The Service Master Key is created by SQL Server setup and is encrypted with the Windows Data Protection API (DPAPI).

In OpManager, during initial start-up (or cold start), Database Master Keys, certificate and Symmetric key are created for the database.

This Symmetric key is used for encrypting and decrypting the data. This support is applicable for SQL Server 2000 and above.

In OpManager, this support is being provided from version 12.

Thank you for your feedback!

Was this content helpful?

We are sorry. Help us improve this page.

How can we improve this page?
Do you need assistance with this topic?
By clicking "Submit", you agree to processing of personal data according to the Privacy Policy.