UserProfileApplication.SynchronizeMIIS: Failed to configure MIIS post database, will attempt during next rerun. Exception: System.Configuration.ConfigurationErrorsException: ERR_START_SERVICE
at Microsoft.Office.Server.UserProfiles.Synchronization.ILMPostSetupConfiguration.ValidateConfigurationResult(UInt32 result)
at Microsoft.Office.Server.Administration.UserProfileApplication.SetupSynchronizationService(ProfileSynchronizationServiceInstance profileSyncInstance).
I tried all possible solutions through online research, but, none of them works.
In the end, I submitted a Microsoft support ticket. It turns out that we have to remove "Forefront Identity Manager Service" from the dependency of windows service "FIMSynchronizationService"
Create a ".reg" file, then add the text below to it, then merge this reg file into the Windows of SharePoint server.
Windows Registry Editor Version 5.00
Then reboot the server. Below is the result.
Now we can start the SharePoint service instance "User Profile Synchronization Service".
I hope this post can save you some headache.
PS: Microsoft support team said they never got this issue before. So I assume it only happens when SharePoint and Database are installed on the same server.