Microsoft SQL Server Management Studio (SSMS)
CADP Key Storage Provider enables the use of CipherTrust Key Management Server (KMS) devices for storage of keys and cryptographic operations such as key creation, deletion, encryption, decryption, and so on. This is a more secure solution because the encryption keys do not reside with encryption data. Data can be encrypted by using encryption keys that only the database user has access to.
This document provides detail of how CipherTrust Ma``nager can be integrated with CADP Key Storage Provider. You must have basic knowledge of using CADP Key Storage Provider and CipherTrust KMS concepts to make full use of the recommendations in this document.
Supported Product Versions
This integration is validated on the following operating system variants:
Windows
- Windows Server 2016 or later
CipherTrust Manager
- CipherTrust Manager 2.11.x LTS or later
CADP Key Storage Provider
- 8.11.0.001 64 bit
SQL Server
- 2016 or later
SQL Server Management Studio
- SSMS 22 (22.3.3)
Note
A fresh installation of the x64 environment is required for this integration.
Prerequisites
Ensure that the CipherTrust Manager is installed and configured. For more details, refer to the CipherTrust Manager Documentation.
SSMS communicates with the CipherTrust Manager using the Network Attached Encryption (NAE)-XML Interface. Ensure that the NAE-XML interface is configured. For more details, refer to the CipherTrust Manager Documentation.
Ensure that the port configured on NAE-XML interface is accessible from the SSMS machine.
Ensure Setting up SSL.
Ensure that the SQL Server is installed on the target machine. For more details, refer to the Microsoft documentation.
Ensure that the SQL Server Management Studio is installed on the target machine. For more details, refer to the Microsoft documentation.
Steps For The Integration
To integrate SSMS with the CipherTrust Manager:
