UserProfileApplication.SynchronizeMIIS: Failed to configure ILM, will attempt during next rerun. Exception: System.Data.SqlClient.SqlException


RUN AS FARMADMIN!!!!!

 

$sync_db = "PROD_SA_UPS_Sync"

$ups_service_app_name = "User Profile Service"

 

 

 

net stop sptimerv4

$syncdb=Get-SPDatabase | where {$_.Name -eq $sync_db}

$syncdb.Unprovision()

$syncdb.Status='Offline'

$ups = Get-SPServiceApplication  | where {$_.Displayname -eq $ups_service_app_name }

$ups.ResetSynchronizationMachine()

$ups.ResetSynchronizationDatabase()

$syncdb.Provision()

net start sptimerv4

 

Start the UserProfileSyncService again


Comments (8)
  1. EJ says:

    This is great, but being new to PowerShell, it would be helpful to a novice to italicize where I need to insert my information for my system.
    Example, second line, for name do I enter my database sync database name? Same with the 5th line. Thanks I appreciate it.

  2. Utwolfapck says:

    You my friend are awesome, this was a perfect solution. Thank you so much! I was having this issued with a scripted install and a 2 web 3 app 1 SQL Farm.

  3. Gavin says:

    Awesome, life saving…..thanks

  4. money says:

    Perfect.

  5. Vincent Verbeek says:

    Thanks, this saved our day. 🙂 It seems this happens when you provision the User Profile Service Application through PowerShell, rather than through the CA UI.

  6. JJ says:

    Thank you! 🙂

  7. Anonymous says:

    In my case (SharePoint 2013 SP1, Windows Server 2012, SQL Server 2014) it was helpful to install KB2878240.

Comments are closed.

Skip to main content