SharePoint 2013 & SQL 2014 Issues with User Synchronization

  • Article

Hello

I would like to tak about a experience that happened to me during a migration at a customer.

It turned out that the UPA was totally stuck starting and after a while stopped. When we were checking the SharePoint logs we found the following

UserProfileApplication.SynchronizeMIIS: Failed to configure MIIS post database, will attempt during next rerun. Exception: System.Configuration.ConfigurationErrorsException: ERR_CONFIG_DB   
at Microsoft.Office.Server.UserProfiles.Synchronization.ILMPostSetupConfiguration.ValidateConfigurationResult(UInt32 result)   
at Microsoft.Office.Server.UserProfiles.Synchronization.ILMPostSetupConfiguration.ConfigureMiisStage2()   
at Microsoft.Office.Server.Administration.UserProfileApplication.SetupSynchronizationService(ProfileSynchronizationServiceInstance profileSyncInstance).

Cheking on our internal Knowledge Base we found that April 2014 CU solved the issue and when you go directly to the KB article page, it states

If you have Microsoft SQL Server 2014, you cannot run profile synchronization in SharePoint Server 2013 SP1 by using the Forefront Identity Management engine.

https://support.microsoft.com/en-us/kb/2760265

So if you are in a considering to migrate to SPS 2013 SP1 from SharePoint 2010 or 2007 and you want to use SQL Server 2014, you must install SPS 2013 SP1 + April 2014 CU to have user synchronization.

THX

Kind Regards.

Héctor Calvarro Martín. SharePoint. Microsoft Premier Field Engineer for EMEA