Debugging · Dynamics CRM 2013 · Migration

CRM 2013: Migration – Cannot open SQL Encryption Symmetric Key because Symmetric Key password does not exist in Config DB

sliong

Upon migrating a CRM database (in our case from CRM 2013 to CRM 2013), we encountered this error when trying to send an email. Everything else seems to work alright apart from sending an email which turns out requires data encryption to be enabled. And since we were migrating the Organisation DB and not the MSCRM Config DB, the encryption key was not migrated along.

Below are the steps we took to resolve the issue:
1. Disable SSL Check (Non HTTPS deployment – if you use HTTPS deployment, skip this step)
Run the following SQL for MSCRM_CONFIG database.

UPDATE [MSCRM_CONFIG].[dbo].[DeploymentProperties]
SET [BitColumn]=1
WHERE ColumnName='DisableSSLCheckForEncryption'

2. Copy Encryption Key from the source CRM Organisation
Go to Settings > Data Management > Data Encryption
Check “Show Encryption Key” and copy the Encryption Key.

3. Change Encryption Key on the target CRM Organisation
Go to Settings > Data Management > Data Encryption
Paste the Encryption Key on the provided textbox and click Change.
Caveat: You must be logged in as a user that is a member of PrivUserGroup when installing CRM.

Cheers,
Sy

2 thoughts on “CRM 2013: Migration – Cannot open SQL Encryption Symmetric Key because Symmetric Key password does not exist in Config DB”

  1. I already did steps listed in this post but each time the async service is sending emails for server side synchronisation, it crashed after few minutes and I get this error message. Only option I have it’s to restart the async service.

    Backend service are installed on a separate server than front end server.

    Thanks

    Reply

    1. Hi Steeve,

      If you’ve done the steps and still have the same issue, I’m afraid the next step is to raise a service ticket with Microsoft.

      Sy

      Reply

Leave a comment