Tuesday, August 18, 2015

Microsoft Dynamics CRM 2013 “Data Encryption Feature Isn’t Activated” error when upgrading from Dynamics CRM 2011

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!


No comments:

Post a Comment