Wednesday, January 21, 2015

SharePoint 2013 with SQL Server 2014, Resolving “UserProfileApplication.SynchronizeMIIS: Failed to configure MIIS post database, will attempt during next rerun. Exception: System.Configuration.ConfigurationErrorsException: ERR_CONFIG_DB”

User profile service synchronization in SharePoint is not the favorite among administrators. If not its prerequisites are addressed properly it will definitely cause you problems. Fortunately those steps are discussed in Technet as well as in some technical blogs.

Although I’ve followed best practices, I had trouble in starting the “User Profile Synchronization Service” service in the services on this server section. It got stuck in Starting and later it showed as Error.

Luckily ULS logs came in to rescue. following is the full error message I received.

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).

It seems that SharePoint Server 2013 farms without April 2014 Cumulative Update does not support user profile synchronization in SQL Server 2014. Following is the exact text from the CU download page (KB)

image

Once it is installed in all SharePoint servers I was able to easily start profile synchronization. I will dig little deeper in to the cause of the issue later. But for the time being will stop in this point. One thing to remember is that you should install SharePoint Server 2013 SP1 prior to the cumulative pack update

1 comment:

Sakthiganesh said...

I had the exact same issue - but even after sql server 2008 R2 native client it didnt work.

To help someone who was in the same boat..

Check your connection between sql server and sharepoint app server. In my scenario, in both places I have TLS 1.2 enabled. But SQL Server 2008 R2 native client does not support 1.2 by default.

You need to install the hotfix https://support.microsoft.com/en-us/help/3135244/tls-1-2-support-for-microsoft-sql-server

Then it works!