Tuesday, June 19, 2012

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

8 comments:

  1. Great work thanks a lot!

    ReplyDelete
  2. Concur, works on sp2013, thank you very much!

    ReplyDelete
  3. Been having this issue in production for the last nine months.This fixed it.You may look like you're twelve but you're pretty awesome.
    Thanks!

    ReplyDelete
  4. Thanks a lot... this solution worked like a magic

    ReplyDelete
  5. Thank You...You saved my job Sir:)...May God Bless You!!!

    ReplyDelete