Hello CRM Community,
I am in the process of migration 3 applications from Dynamics 2015 v7 on premise to Dynamics 365 v9 on premise. Ive been through the threads on lost or missing encryption keys and still not finding anything to help resolve my specific issue.
Heres what ive done for each application:
- Copy each ORG DB from a 2014 sql server that was on the v7 Dynamics platform to a 2016 sql server thats on a v8 Dynamics platform
- Imported the each Org on the deployment manager on v8 so that it does the necessary CRM updates on the ORG DBs.
- I didnt do anything to the Orgs on v8 after importing them. Not sure if I was suppose activate the encryption key here, but it wouldnt have been copied over to v9 anyways so not sure if this wouldve cause my issue here
- Copied each ORG DB from the 2016 sql server they were on to a 2019 sql server on a v9 Dynamics platform
- Imported them through the Deployment Manager on v9 and they are stood up and working.
Out of these 3 Orgs i have on the v9 Dynamics platform, only 1 has allowed me to activate data encryption with same source key! The other 2 give me the "doesn’t match the original encryption key". Its really confusing to me only this 1 has allowed me when I know for a fact what the source keys are!
I have the source Orgs, DBs, and Config DB from the 2015 v7 platform. Each Org had Encryption Enabled to where I can pull them straight from CRM UI. Ive done the SQL to query them from MSCONFIG db and used a C# Console App to decrypt it like here: https://szczepan.net/?p=152 It generates the same ones ive pulled manually.
Ive tried different copy and pasting methods too!
I would rather avoid making new encryption keys because Im not too sure what all that might impact as ive never messed with this.
Any help would be appreciated!