Tuesday, August 25, 2015

Mail address are not synchronizing in SharePoint 2013

I have SharePoint 2013 configured in an environment that does not have a mail server on premise. I could not generate emails from SharePoint.

This was caused due to the User Profile Service Application was trying to sync the Work Email with the AD attribute ‘ProxyAddresses’.

The attribute ‘proxyAddresses’ is normally filled with information given by for example Exchange. The attribute is not set because we don’t have these kind of servers.

Configure the user properties import for Work Email:

  • First check if the User Profile Sync Service has started
  • Go to the User Profile Service Application
  • Open ‘Manage User Properties’ and navigate to Work Email
  • Remove the Synchronizing mapped field “proxyAddresses” and add new mapping of field “mail”

Start a full sync after changing this setting and the mail addresses will be filled in for users.


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!