Yesterday I came across with one issue after we did upgrade of Dynamics CRM 2011 to Dynamics CRM 2013 Service Pack 1. Email routines stopped working as Data Encryption feature was not active.
We encountered first issue to open Data Encryption window from Data Management.
As we had on premise implementation and didn’t have SSL. To avoid SSL check in Dynamics CRM we executed the below steps.
- Open SQL Server Management Studio.
- Click New Query and select MSCRM_CONFIG database.
- Run the command
- UPDATE DeploymentProperties SET BitColumn = 1 WHERE ColumnName = ‘DisableSSLCheckForEncryption’
After we tried to activate Data Encryption but it generated error “Encryption key was not activated”. “Data Encryption can’t be activated because the encryption key doesn’t match the source encryption key used to encrypt the data.”
We found CRM users & Queues password were saved in Dynamics CRM 2011 and Dynamics CRM has requirement to activate Data Encryption to save such details.
Once it was done we executed following SQL scripts in CRM Organization database.
update EmailServerProfile set IncomingPassword = null
update EmailServerProfile set OutgoingPassword = null
update Mailbox set Password = null
update Queue set EmailPassword = null
update UserSettings set EmailPassword = null
We were able generate Data Encryption key after performing all of the above steps.
Hopefully it shall be helpful for others as well. Cheers!