Problem with starting Sharepoint 2013 User Profile Synchronization - FIM Service fails

Question

Hello,

I am supporting several small Sharepoint farms. Some of them experience strange issues with the User Profile Synchronization service.

I went through a lot of issues, searched a lot online, went through all sorts of user rights and other settings. I have now hit a wall.

On all machines, when I try to start the profile synchronization from Central Administration, it starts and then stops after a few minutes. The only thing I see in the ULS logs is this:

Unexpected Maximum number of retries done for starting FIM SpService. Please look at ULS logs and event viewer to look for the root cause of the failure.

However, I dont see any error messages indicating the root cause.

When I try to manually start the FIM Service (Forefront Identity Management Service) via Windows, in half of the cases it doesn't work, in the others it has no effect. When an error is thrown, I can see this in the Eventlog:

The server encountered an unexpected error and stopped.

"BAIL: MMS(20096): sql.cpp(252): 0x80040154 (Class not registered)
BAIL: MMS(20096): storeimp.cpp(234): 0x80040154 (Class not registered)
ERR: MMS(20096): server.cpp(373): Failed to connect to the database User Profile Service Application_SyncDB_e28c8304af814e32987a2f39d088913a on USFKLH99A71SRV
BAIL: MMS(20096): server.cpp(374): 0x80040154 (Class not registered)
BAIL: MMS(20096): server.cpp(3860): 0x80040154 (Class not registered)
BAIL: MMS(20096): service.cpp(1539): 0x80040154 (Class not registered)
ERR: MMS(20096): service.cpp(988): Error creating com objects. Error code: -2147221164. This is retry number 0.
BAIL: MMS(20096): clrhost.cpp(283): 0x80131022
BAIL: MMS(20096): scriptmanagerimpl.cpp(7670): 0x80131022
BAIL: MMS(20096): server.cpp(251): 0x80131022
BAIL: MMS(20096): server.cpp(3860): 0x80131022
BAIL: MMS(20096): service.cpp(1539): 0x80131022
ERR: MMS(20096): service.cpp(988): Error creating com objects. Error code: -2146234334. This is retry number 1.
BAIL: MMS(20096): clrhost.cpp(283): 0x80131022
BAIL: MMS(20096): scriptmanagerimpl.cpp(7670): 0x80131022
BAIL: MMS(20096): server.cpp(251): 0x80131022
BAIL: MMS(20096): server.cpp(3860): 0x80131022
BAIL: MMS(20096): service.cpp(1539): 0x80131022
ERR: MMS(20096): service.cpp(988): Error creating com objects. Error code: -2146234334. This is retry number 2.
BAIL: MMS(20096): clrhost.cpp(283): 0x80131022
BAIL: MMS(20096): scriptmanagerimpl.cpp(7670): 0x80131022
BAIL: MMS(20096): server.cpp(251): 0x80131022
BAIL: MMS(20096): server.cpp(3860): 0x80131022
BAIL: MMS(20096): service.cpp(1539): 0x80131022
ERR: MMS(20096): service.cpp(988): Error creating com objects. Error code: -2146234334. This is retry number 3.
BAIL: MMS(20096): service.cpp(1002): 0x80131022
Forefront Identity Manager 4.0.2450.51"

Now I have no idea how to further investigate this. Deleting/recreating the profile sync app hasn't worked and reinstalling the entire system isn't that easy as these are corporate systems. Does anyone have any idea how I could further investigate this?

Answer 1

Hello @Ziegler, Aaron (IOT DS EVO BS ITS PFS) ,

Welcome to Q&A Forum!

Please perform following troubleshootings:

1.Check whether the Synchronization options of User Profile Service Application is User SharePoint Profile Synchronization.

2.Check that the accounts of the User Profile Synchronization Service, Forefront Identity Manager Service, and Forefront Identity Manager Synchronization Service are consistent.

3.Please install the latest patch package for SharePoint 2013.

4.If it is still not possible. Please delete the service and create a new one. You refer to this article to create and start User Profile Service.

Here is a similar case for your reference:

Cannot Start User Profile Synchronization Service

Thanks,
Echo Du

=============================

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I tried all of that without effect. After a few minutes, the sync-service goes back to "stopped" and the FIM-services are then "disabled".

I'll install the latest patches this week, maybe I'll get lucky.

Answer 3

Unfortunately nothing worked. The error persists. I am currently out of ideas...