Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Unanswered

Dynamics 365 on-premise data encryption key

(1) ShareShare
ReportReport
Posted on by 15

We have a transfer batch for reapplying organization between 2 db servers (prod to staging). This batch recovers a backup of the prod database, exchanges it with the database currently in staging and restores the organization. A second part restores the encryption key.

This batch has always worked until now, however, we moved the production SQL instance to a new server and since then the encryption key not recognized anymore on the staging server even though the databases are the same.

We performed several checks: Copy key manually, deactivate SSL checking but nothing happens, the key is not recognized. Checking if the user belongs to the PrivUserGroup.

Are there any other possible checks? Do you know what this encryption technology in SQL Server is based on?

Thks,

  • cyvo Profile Picture
    cyvo 15 on at
    RE: Dynamics 365 on-premise data encryption key

    Hello please note message : Cannot perform 'activate' because the encryption key doesn’t match the original encryption key that was used to encrypt the data.

  • edmunch Profile Picture
    edmunch on at
    RE: Dynamics 365 on-premise data encryption key

    Do you have a screenshot of the message that pops up?  Does it specifically say that the key is not recognized or do you get a popup error with further details?

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans