Uninstalling CAKM for Microsoft SQL Server EKM Provider

In case you need to uninstall the CAKM for Microsoft SQL Server EKM Provider, the InstallShield wizard also provides this capability. If the wizard detects that the provider has already been installed, it allows you to remove the current installation.

Before you uninstall the provider, perform the following steps:

1. Unencrypt the database using the following command:

   USE <db_name>;
   ALTER DATABASE <db_name>
   SET ENCRYPTION OFF;
   GO
   

2. Run the following query to check the encryption status of the database:

   select db.name,
   case dbe.encryption_state
   when 0 then 'No database encryption key present, no encryption'
   when 1 then 'Unencrypted'
   when 2 then 'Encryption in progress'
   when 3 then 'Encrypted'
   when 4 then 'Key change in progress'
   when 5 then 'Decryption in progress'
   when 6 then 'Protection change in progress (The certificate or asymmetric key that is encrypting the database encryption key is being changed.)'
   end EncryptionState
   , dbe.percent_complete
   from sys.dm_database_encryption_keys dbe
   inner join sys.databases db on db.database_id = dbe.database_id
   

3. Drop the database encryption key using the following command:

   USE <db_name>;
   GO
   DROP DATABASE ENCRYPTION KEY
   

4. Drop the credential using the following steps:

   1. Use alternate login.

      ALTER LOGIN <login_name>
      

   2. Delete the credential from SQL Server.

      DROP CREDENTIAL <credential_name>
      

   3. Delete the login from SQL Server

      DROP LOGIN <login_name>
      

5. Delete the asymmetric key from the provider.

   DROP ASYMMETRIC KEY <key_name_in_sql_server>
   

6. Drop the CAKM for Microsoft SQL Server EKM provider.

   DROP CRYPTOGRAPHIC PROVIDER <provider_name>
   

To uninstall the CAKM for Microsoft SQL Server EKM provider silently, execute the following command:

setup.exe /x /s /v/qn

To uninstall the provider using GUI:

1. Double-click the setup executable to launch the InstallShield Wizard. The wizard detects the current installation.

2. Click Next to access the Program Maintenance screen.

3. Select Remove and then click Next.

4. Click Remove.

5. After the files are uninstalled, click Finish to complete the process.

Moreover, you can also uninstall the provider from the Control Panel.