I have restored my managed metadata db and user profile db's on a new SharePoint 2013 farm with a SQL 2012 server. I recreated both service applications with the restored db's (created a new sync db otherwise I can't start the sync service). The managed metadata and user profile service application are working. No errors what so ever.
I now try to start the "User Profile Synchronization Service" This process takes a while but ends and the service is still stopped. During this time it is stuck in the famous starting state.
I get the following errors in the ULS Looks like something in combination with the managed metadata service :
ILM Configuration: Setting policy for service account ILM Configuration: Configuring database ILM Configuration: Re-starting mms service ILM Configuration: Checking mms service ILM Configuration: Error 'ERR_START_SERVICE'. 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). UserProfileApplication.SynchronizeMIIS: End setup for 'User Profile Service Application'.ILM Configuration: Changing service account credentials
I have created multiple SharePoint 2013 farms in the past so all the requirements needed for starting the "User Profile Synchronization Service" are correct. All permissions etc.. are set.