SharePoint 2013 & SQL 2014 Issues with User Synchronization
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.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.
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.
Héctor Calvarro Martín. SharePoint. Microsoft Premier Field Engineer for EMEA