none
UserProfileApplication.SynchronizeMIIS: Failed to configure MIIS post database

    Question

  • Hello all,

    Greetings,

    I am facing this error at one of my customer SharePoint 2013 environment. "UserProfileApplication.SynchronizeMIIS: Failed to configure MIIS post database".

    Scenario:

    We are trying to run User Profile Synchronization service, but every time after 5 mins in starting status, it ended up with stopped .

    Environment setup:

    2 WFE

    1 APP

    1 SQL 2012

    Previously we have SQL Server 2008 R2, and we were getting the same error, In order to get over to this problem, we migrate the SQL Server from 2008 R2 to 2012.

    We have gone through each and every blog / forum post and try to rectify based on the recommended steps, but of no use.

    The following article link states four Possible causes

    http://blogs.msdn.com/b/spses/archive/2015/06/16/err-config-db-while-starting-the-upa-synchronization-service-in-sharepoint-2010-2013.aspx

    Possible Cause 1: This is due to insufficient privileges for the
    SharePoint Farm Account on the Sync DB (not the Config DB!). You need to
    add the farm account to the Sync DB users as DBO with a default schema
    of DBO and then start UPS again.

    We have verified that  SharePoint Farm Account is DBO with default schema of DBO.

    Possible Cause 2: Incorrect
    Pre-requisites installed , i.e SQL server Native Client 2012 /2014 is
    installed , while the Requirement is to have a SQL 2008 /2008 Sp1 .
    Details here : http://technet.microsoft.com/en-us/library/cc262485.aspx#reqOtherCap

    We have verified that on all the SharePoint boxes, 2008 R2 native client is installed

     

    Possible
    Cause 3: If you use SQL server 2014 to host the Sync DB or Moved your
    Databases to SQL 2014 ( Sharepoint 2013 ) , then there is a known issues
    & you need to Update to April 2014 CU or above for Sharepoint 2013 ,
    https://support.microsoft.com/en-us/kb/2760265

      We have SQL Server 2012, not SQL Server 2014


    Shakir Majeed Khan, MCITP (SharePoint 2010), MCPD(SharePoint 2010)

    Thursday, July 23, 2015 12:05 PM

Answers

All replies