Failed to configure MIIS post database while provision User profile Synchronization Service

When I was provisioning the User profile Synchronization service in SharePoint 2013, the UPS service got stuck on starting status for more than 4 hours and identified the “Failed to configure MIIS post database” in the SharePoint log file.

“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”

For the above issue, found that SQL Native client 2008 R2 didn’t installed on the SharePoint server which is the prerequisite of SharePoint 2013.

After I installed SQL 2008 R2 Native Client on the SharePoint Server 2013 and then able to re-provision the user profile synchronization service successfully.

ILM Certificate could not be created while provisioning UPS in SharePoint 2013

When I was provisioning the User profile Synchronization service in SharePoint 2013, the UPS service started and stopped and identified the “ILM Certificate could not be created: Cert Step 2 could not create” in the Event Log.

Then tried the below fix and worked fine for me.

1. Log in to the SharePoint 2013 server

2. Start-> Run->MMC-> Add/Remove snap-in

3. In the left panel, Select certificate->select computer Account->Next and Finish

4. Expand the certificate tree in the left panel and remove “ForeFrontIdentityManager Certificates from the below three folder locations

a. Personal

b. Trusted Root Certification Authorities

c. Trusted People

5. Once you removed ForeFrontIdentityManager Certificates, then try re-provision the User profile synchronization service.