web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer Service forum / Data Encryption key er...
Customer Service forum

Data Encryption key error in workflow

(0) ShareShare
ReportReport
Posted on by shantanu misra 5

Hi,

i m using crm on-premise 2016 Whenever a new record is created in account entity, an email is  sent regarding the successful completion of form. Also a email is sent whenever a user selects forget password link. Both the workflows are not working and error : "Cannot open Sql Encryption Symmetric Key because Symmetric Key password does not exist in Config DB." is shown. But the encryption key is present in CRM and data encryption is also active.  Please provide a solution for this error.

Categories:
Activities
  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 1,032 Moderator on at

    Hi shantanu misra,

    We will need to examine your workflow in order to solve this issue.

  • shantanu misra Profile Picture
    shantanu misra 5 on at

    Hi Adrian,

    Thanks for replying. This is a custom workflow which fires whenever a record is created in account entity and it created a record in login master entity. A email is also sent regarding the login details. The record is created in login entity but the email is never sent and status is always waiting even after resuming the workflow. Here is the image attached of the error.

    capture_5F00_20190411142713.png

  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 1,032 Moderator on at

    Hi shantanu misra,

    This issue can occur if your instance was set up by taking a database backup from another CRM instance where data encryption was activated. If this is the cause of your problem then you will need to update the encryption key on your CRM instance with the encryption key from the original CRM instance.

    To check your current encryption key and change your encryption key follow these steps:

    1. Sign in to Microsoft Dynamics CRM as a user with the system administrator security role.
    2. Go to Settings > Data Management > Data Encryption.
    3. In the Data Encryption dialog box, select Show Encryption Key, in the Current encryption key box select the encryption key, and copy it to the clipboard.

    However, if the Microsoft Dynamics CRM website is not configured for HTTPS/SSL, the Data Encryption dialog box will not be displayed.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Customer Service

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans