Dynamics 365 on-premise data encryption key

(1) Share

Report

Posted on by cyvo

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,

Categories:

Administration and Setup

All responses (2)

Answers (0)

cyvo 15 on at

Like (0)

Report

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 on at

Like (0)

Report

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?