Hey everyone,

I've just installed sharepoint 2013 on sql always on 2014 with all the latest updates, everything is running ok but i can't start the User Profile Synchronization Service. I've been searching for a few days but cant seem to find a solution.

SP_farm account has all the rights on the db's, when i try to start fim sync service manually i get in event viewer system:

The Forefront Identity Manager Synchronization Service service terminated with the following service-specific error: 
%%2148732962

And in app: 

 

The server encountered an unexpected error and stopped.

 "BAIL: MMS(6324): sql.cpp(2325): 0x80230404 (The operation failed because the attribute cannot be found)
ERR: MMS(6324): storeimp.cpp(5813): Failed to get computer id info from db.
BAIL: MMS(6324): storeimp.cpp(5815): 0x80230447 (Service start up has failed.  Cannot read computer_id from the FIM Synchronization Service database.)
BAIL: MMS(6324): storeimp.cpp(5892): 0x80230447 (Service start up has failed.  Cannot read computer_id from the FIM Synchronization Service database.)
BAIL: MMS(6324): storeimp.cpp(482): 0x80230447 (Service start up has failed.  Cannot read computer_id from the FIM Synchronization Service database.)
BAIL: MMS(6324): server.cpp(388): 0x80230447 (Service start up has failed.  Cannot read computer_id from the FIM Synchronization Service database.)
BAIL: MMS(6324): server.cpp(3860): 0x80230447 (Service start up has failed.  Cannot read computer_id from the FIM Synchronization Service database.)
BAIL: MMS(6324): service.cpp(1539): 0x80230447 (Service start up has failed.  Cannot read computer_id from the FIM Synchronization Service database.)
ERR: MMS(6324): service.cpp(988): Error creating com objects. Error code: -2145188793. This is retry number 0.
BAIL: MMS(6324): clrhost.cpp(283): 0x80131022 
BAIL: MMS(6324): scriptmanagerimpl.cpp(7670): 0x80131022 
BAIL: MMS(6324): server.cpp(251): 0x80131022 
BAIL: MMS(6324): server.cpp(3860): 0x80131022 
BAIL: MMS(6324): service.cpp(1539): 0x80131022 
ERR: MMS(6324): service.cpp(988): Error creating com objects. Error code: -2146234334. This is retry number 1.
BAIL: MMS(6324): clrhost.cpp(283): 0x80131022 
BAIL: MMS(6324): scriptmanagerimpl.cpp(7670): 0x80131022 
BAIL: MMS(6324): server.cpp(251): 0x80131022 
BAIL: MMS(6324): server.cpp(3860): 0x80131022 
BAIL: MMS(6324): service.cpp(1539): 0x80131022 
ERR: MMS(6324): service.cpp(988): Error creating com objects. Error code: -2146234334. This is retry number 2.
BAIL: MMS(6324): clrhost.cpp(283): 0x80131022 
BAIL: MMS(6324): scriptmanagerimpl.cpp(7670): 0x80131022 
BAIL: MMS(6324): server.cpp(251): 0x80131022 
BAIL: MMS(6324): server.cpp(3860): 0x80131022 
BAIL: MMS(6324): service.cpp(1539): 0x80131022 
ERR: MMS(6324): service.cpp(988): Error creating com objects. Error code: -2146234334. This is retry number 3.
BAIL: MMS(6324): service.cpp(1002): 0x80131022 
Forefront Identity Manager 4.0.2450.49"

Has anyone encountered this or know a solution?

Kind regards,

Borrie

*Edit I've noticed that in the Sync Database in table dbp.mms_server_configurtion alot of fields are null

• Edited by Borrie 17 hours 6 minutes ago

Hi Borrie,

In your post, you said that installed sharepoint 2013 on sql always on 2014 with all the latest updates.

Did you mean all the latest updates for SharePoint 2013 have been installed?

I recommend to check the build number of SharePoint in Central Administration.

Here is a similar thread for your reference:

http://sharepoint.stackexchange.com/questions/98076/provisioning-user-profile-service-will-not-start

Best regards.

Victoria

You don't need to start the FIM service manually. Make sure the service account used is a member of the local administrators group then start the User Profile Synchronisation service through Central Administration. If it fails consult the ULS logs.