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



$sync_db = "PROD_SA_UPS_Sync"

$ups_service_app_name = "User Profile Service"




net stop sptimerv4

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



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




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:


  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