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!


1 comment:

  1. Roulette is a casino recreation named after the French word meaning little wheel which was likely developed from the Italian recreation Biribi. Despite being called Cosmic Slot, the casino provides every kind of different video games, but the “Cosmic” half is true, because the platform does use the universe as its theme. After partnering with multiple of} software developers, Cosmic Slot accumulated over 3,a hundred out there video games. You can deposit money in AUD by utilizing Visa, Mastercard, Neosurf, Mifinity, and Bitcoin, and play any of them at any 토토사이트 time. In case of any issues, buyer assist is on the market by way of e-mail, live chat, phone name, and Telegram. It's not a direct connection, it's not as if Apple gets all the actual money you place into digital slot machines — but it does get a fee for the in-app forex that gambling apps can sell you.