Hi.

Im having problem with staring User Profile Synchronization Service.
When i use ULSViewer i get the following:

ILM Configuration: Validating account.
ILM Configuration: Validating the system groups
ILM Configuration: Setting up WMI
ILM Configuration: Setting required permissions
ILM Configuration: Create install config file
ILM Configuration: Update source project
ILM Configuration: Changing service account credentials
ILM Configuration: Setting policy for service account
ILM Configuration: Configuring database

And then the following error:

UserProfileApplication.SynchronizeMIIS: Failed to configure MIIS post database, will attempt during next rerun. Exception: System.Runtime.InteropServices.SEHException (0x80004005): External component has thrown an exception.    
 at Microsoft.Office.Server.UserProfiles.Synchronization.ILMPostSetupConfiguration.ConfigureMiisStage2()    
 at Microsoft.Office.Server.Administration.UserProfileApplication.SetupSynchronizationService(ProfileSynchronizationServiceInstance profileSyncInstance).

Env: One Sharepoint 2013 Enterprise Server (Sept CU) with databases on a dedicated SQL 2012 Server. 

I have done/checked:
Farm account permissions in AD/locally/UPA/SQL.
Sync account permissions.
Cleared Config Cache.
Checked SyncDatabaseID in FIMSyncService - Parameters in regedit.
Delete/recreate UPA multiple times with GUI.

I found this article http://marclognoul.eweb703.discountasp.net/itblog-en/post/2013/08/09/SharePoint-2013-User-Profile-Service-Provisioning-vs-Custom-PowerShell-Profile.aspx but cant find a profile in either C:\Windows\System32\WindowsPowerShell\v1.0 or C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\CONFIG\POWERSHELL

Any help is appreciated.

Simon

check this blog

http://blogs.technet.com/b/sp/archive/2013/05/29/http-www-blogger-com-blogger-g-blogid-8070685728411204795-editor-target-post-postid-706076184673021818-onpublishedmenu-overviewstats-onclosedmenu-overviewstats-postnum-23-src-postname.aspx

You can check this link too

https://autospinstaller.codeplex.com/workitem/20428

Did the UPS work before?

Have you followed the steps from Spence Harbar's Rational Guide to implementing SharePoint Server 2010 User Profile Synchronization (which applies to SharePoint 2013 as well)?

Hi John.

I'd tried that before, but gave it a second try and still no success. 

Regarding the AutoSPInstaller link, no success there either.

Hi Jason.

It was working before but the server hadnt been updated with Windows Update in over a year so we updated it and then it stopped working. 

I installed Sept CU to see if it would resolve the problem, but it didnt.

I have been using Harbars guide, and also been looking in his Stuck on Starting: Common Issues with SharePoint Server 2010 User Profile Synchronization but it have not been helping me.

Simon

Hi Simon,

Here is the solution for this problem. Kindly follow given steps in below mentioned URL

http://blogs.technet.com/b/sajiths/archive/2014/04/12/user-profile-synchronization-service-stuck-in-39-starting-39-state-sharepoint2013.aspx

Hope this is helpful to you. If this works, Please mark it as Answered.

Regards,

Dharmendra Singh (MCPD-EA | MCTS)

Blogs : http://sharepoint-community.net/profile/DharmendraSingh

Hi Dharmendra.

Sorry, that didnt work either. Still the same error. 

Note; I didnt have the same error as Sajith in your link.

Hi Simon,

According to your description, my understanding is that you got an error when you started User Profile Synchronization service.

Whether you installed PowerPivot for SharePoint 2013. If yes, please re-install it, compare the result.

Please login your SharePoint server, and check whether you installed Microsoft SQL Server 2012 Native Client. If yes, uninstall it under control panel and replace it with Microsoft SQL Server  2008 R2 Native Client.

Best Regards,

Wendy

Hi Wendy.

PowerPivot isnt installed.

Both 2012 and 2008 R2 Native Client was installed so I uninstalled 2012 Native.

Same error as before: 

UserProfileApplication.SynchronizeMIIS: Failed to configure MIIS post database, will attempt during next rerun. Exception: System.Runtime.InteropServices.SEHException (0x80004005): External component has thrown an exception.    
 at Microsoft.Office.Server.UserProfiles.Synchronization.ILMPostSetupConfiguration.ConfigureMiisStage2()    
 at Microsoft.Office.Server.Administration.UserProfileApplication.SetupSynchronizationService(ProfileSynchronizationServiceInstance profileSyncInstance).

Simon Bergwall

hi,

We had similar issue, below steps helped us to resolve it

In SQL >> security >> your UPSA service account >> right click "Properties" >> User mapping >> check sync DB is mapped with farm account.

Also need to provision sync db, first stop UPS service

Script to provision UPS

# Loads the SharePoint 2010 PowerShell extensions 
Add-PSSnapIn Microsoft.SharePoint.PowerShell  

# Sets variable for User Profile Service Application: enter the name of your UPA in quotes, replacing the "UPA" example
$upa = Get-SPServiceApplication |?{$_.displayname -eq "User Profile Service"}

# Sets variable for service instance: enter your User Profile Synchonization Service instance ID/GUID in quotes
# which can be found by running "Get-SPServiceInstance" in PowerShell manually and copying the ID
$profsync = Get-SPServiceInstance |?{$_.id -eq "f3a2ecd6-f9fc-42cb-8451-3cf630bb1c86"}

# Sets variables for farm account and password: enter your password in quotes
$farmacctpwd = ConvertTo-SecureString -AsPlainText -String "hjhjhd" -Force
$farmacct = (get-spfarm).defaultserviceaccount

# Sets variable for synchronization server: enter your server name in quotes
$syncServer = "Server Name"
 if($profsync.Status -eq "disabled")
 {
  Write-Host "Provisioning User Profile Synchronization Service"
  $upa.SetSynchronizationMachine($syncServer, $profsync.ID, $farmacct.LookupName(), $farmacctpwd)
 }
 else
 { 
  write-host "Profile Synchronization Service is"$profsync.Status
 }

Regards

PT

• Proposed as answer by Tandel Prasad Thursday, October 09, 2014 11:23 AM
• Unproposed as answer by Tandel Prasad Thursday, October 09, 2014 11:23 AM
• Edited by Tandel Prasad Thursday, October 09, 2014 11:33 AM
• Proposed as answer by Inderjeet Singh JaggiMVP, Moderator Wednesday, October 22, 2014 7:53 AM

Every time I get issues like this I start at the beginning of that guide and triple check each setting. It is normally caused by assumptions or basic mistakes, (at least in my experience it is).

Presumably you're on SP1 + CU?

• Edited by Alex BrassingtonMicrosoft community contributor Thursday, October 09, 2014 11:41 AM
• Proposed as answer by Inderjeet Singh JaggiMVP, Moderator Wednesday, October 22, 2014 7:53 AM

Is there a solution, Simon?

I have exactly the same issue.

Hi Benjamin.

It wasn't harder than I had to delete the FIM cerificates and start from the beginning.
Certificates (Local Computer) - Trusted Root Certification Auth - Certificates - ForefronIdentityManager.

Also check Personal and Trusted People for multiple certs. 

Simon

Hi Simon,

thank you for your reply. Start from the beginning, do you mean reconfigure the ups?

Benjamin

I stopped User Profile Synchronization Service and User Profile Service, deleted the service application and started from scratch. 

I used this  flowchart for an easy overview when i did the troubleshooting. I also had ULSViewer running with Category = User Profiles.

I hope this will help you somewhat. 

Simon

Hi Simon,

I'm in the exact same situation as you. I tried everything I found on internet without success. Spent already 2 days on it and I still have this exception in ULSViewer when I try to start the User Profile Synchronization Service: 

UserProfileApplication.SynchronizeMIIS: Failed to configure MIIS post database, will attempt during next rerun. Exception: System.Runtime.InteropServices.SEHException (0x80004005): External component has thrown an exception.    
 at Microsoft.Office.Server.UserProfiles.Synchronization.ILMPostSetupConfiguration.ConfigureMiisStage2()    
 at Microsoft.Office.Server.Administration.UserProfileApplication.SetupSynchronizationService(ProfileSynchronizationServiceInstance profileSyncInstance).

One thing I remarked reading this post was that our SQL Server is in v.11.0.2100.60 (so apparently never updated) and on the back-end we have "Microsoft SQL Server 2008 R2 Native Client". I think I'm going to try to install the 2012 native client on backend (and if still not working try to ask to sys admin to update the sql server ;-)).

Did you solve this problem? If yes, how?

Thanks,
Bastien

Hi Bastien.

My problem was that i needed to delete old FIM-certificates (under Trusted Root Cert, also check Personal and Trusted People). 
Try and remove everything related to UPS (Service application, databases, certificated etc) and start to double check permissions for service accounts.

Hope this helps :)

Simon

Hi Simon, 

Thanks for your answer. I already checked the certificates on the machine but I don't have any related to FIM.

Bastien