Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
UserProfileApplication.SynchronizeMIIS: Failed to configure MIIS post database RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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)

    • Moved by Just Karl Friday, July 24, 2015 2:58 PM Looking for the proper forum.
    Thursday, July 23, 2015 12:05 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Following are more information

    Possible
    Cause 4: Connectivity issues to SQL server , like Wrong Alias . Start
    -->Run-->Cliconfg to check & configure aliases

    As I have mentioned that we have migrated the Database from 2008 R2 to 2012, we have done entry into the SQL Alias in order to connect with SQL Server.

    Previously it was with named instance, now to check that if we make the instance as default that would help, so we make that as default instance. I have followed SQL Alias post and other blog post in order to do SQL Aliasing. But again its of no use.

    Possible cause 4 : Using FDQN of SQL server while creating the SharePoint server Farm .

    Our Environment used FQDN of SQL Server.

    Following steps we have already done with

    Do let me know if you know any thing else which might be helpful to resolve this issue.  

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

    Thursday, July 23, 2015 12:06 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    The TechNet Sandbox forum is designed for users to try out the new forums functionality. Please be respectful of others, and do not expect replies to questions asked here.

    As it's off-topic here, I am moving the question to the Where is the forum for... forum.

    Karl

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer.
    My Blog: Unlock PowerShell
    My Book: Windows PowerShell 2.0 Bible
    My E-mail: -join('6D73646E5F6B61726C406F75746C6F6F6B2E636F6D'-split'(?<=\G.{2})'|%{if($_){[char][int]"0x$_"}})

    Friday, July 24, 2015 2:56 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    The SQL Server forums are over here:

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home

    SharePoint forums are over here:

    http://social.technet.microsoft.com/Forums/sharepoint/en-US/home.

    Karl

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer.
    My Blog: Unlock PowerShell
    My Book: Windows PowerShell 2.0 Bible
    My E-mail: -join('6D73646E5F6B61726C406F75746C6F6F6B2E636F6D'-split'(?<=\G.{2})'|%{if($_){[char][int]"0x$_"}})

    Friday, July 24, 2015 2:58 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Moved!

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

    Sunday, July 26, 2015 1:02 PM