Announcements
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,
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.
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?
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156