Database
Microsoft SQL Server TDE
Configuring EKM on the SQL Server
2min
1
Open the SQL Server Management Studio application.
2
Connect to the SQL Server
3
Open a Query window and execute the following commands:
1
Open a new Query window in SQL Server Management Studio and execute the following command:
If you encounter the error, Cannot initialize cryptographic provider. Provider error code: 1. (Failure - Consult EKM provider for details), perform the following steps:
- Switch the Server Authentication type to Windows Authentication.
- Right-click the DB server, select Properties, and go to the Security tab.
- Change the Server Authentication type from SQL & Windows Authentication to Windows Authentication.
Updated 26 Aug 2024
Did this page help you?