Hi,

I moved DB's Profil, Social and Sync from a SharePoint 2013 UAT to a ShrePoint 2013 PROD

I retrived all my information (User Properties, User Profiles .... ) but I have still a problem with the User Profile Synchronization Service which can not be started.

I would like to avoid to reinstall User Profile Service.

Every rights seem to be correct on the DB's, but in events viewer, one of the error is  :

The server encountered an unexpected error and stopped.
 
 "BAIL: MMS(7648): storeimp.cpp(5896): 0x8023060d (The computer_id in the database does not match this computer.)
BAIL: MMS(7648): storeimp.cpp(482): 0x8023060d (The computer_id in the database does not match this computer.)
BAIL: MMS(7648): server.cpp(388): 0x8023060d (The computer_id in the database does not match this computer.)
BAIL: MMS(7648): server.cpp(3860): 0x8023060d (The computer_id in the database does not match this computer.)
BAIL: MMS(7648): service.cpp(1539): 0x8023060d (The computer_id in the database does not match this computer.)
ERR: MMS(7648): service.cpp(988): Error creating com objects. Error code: -2145188339. This is retry number 0.
BAIL: MMS(7648): clrhost.cpp(283): 0x80131022 
BAIL: MMS(7648): scriptmanagerimpl.cpp(7670): 0x80131022 
BAIL: MMS(7648): server.cpp(251): 0x80131022 
BAIL: MMS(7648): server.cpp(3860): 0x80131022 
BAIL: MMS(7648): service.cpp(1539): 0x80131022 
ERR: MMS(7648): service.cpp(988): Error creating com objects. Error code: -2146234334. This is retry number 1.
BAIL: MMS(7648): clrhost.cpp(283): 0x80131022 
BAIL: MMS(7648): scriptmanagerimpl.cpp(7670): 0x80131022 
BAIL: MMS(7648): server.cpp(251): 0x80131022 
BAIL: MMS(7648): server.cpp(3860): 0x80131022 
BAIL: MMS(7648): service.cpp(1539): 0x80131022 
ERR: MMS(7648): service.cpp(988): Error creating com objects. Error code: -2146234334. This is retry number 2.
BAIL: MMS(7648): clrhost.cpp(283): 0x80131022 
BAIL: MMS(7648): scriptmanagerimpl.cpp(7670): 0x80131022 
BAIL: MMS(7648): server.cpp(251): 0x80131022 
BAIL: MMS(7648): server.cpp(3860): 0x80131022 
BAIL: MMS(7648): service.cpp(1539): 0x80131022 
ERR: MMS(7648): service.cpp(988): Error creating com objects. Error code: -2146234334. This is retry number 3.
BAIL: MMS(7648): service.cpp(1002): 0x80131022 
Forefront Identity Manager 4.0.2450.51"

Hi,

I'd suggest you to disable and re-enable the user profile sync service (FIMSynchronizationService) so connections can be refreshed. Once done, re-check the service status. 

Regards.

Already done, without success, do you know if it's possible to reinstall User Profile Synchronization Service without to reinstall User Profile Service ?

Hi Fixit,

As your description, my understanding is that you could not start user profile synchronization service after user profile service application database migration.

Please try to stop user profile service and timer service, then run the following PowerShell commands(replace with name of your User Profile Application):

$upa = Get-SPServiceApplication  -Name "User Profile Service Application"
$upa.ResetSynchronizationMachine()
$upa.Update()

After that, start timer service and user profile service, then user profile sync service, compare the result.

There are two similar post for your reference:

https://social.technet.microsoft.com/Forums/sharepoint/en-US/406859dc-2a4b-4c57-aedb-0cec5ad869a3/user-profile-synchronization-service-wont-start

http://blog.avanade.com/asg-collaboration-services/migration-2/migration-of-a-user-profile-service-application/

Best Regards,

Wendy

HI,this could be of many reasons,I would suggest you to check the below for troubleshooting of the issue.

Ensure to restart the user profile service and synchronization service
        Ensure to restart the FIM services
        Ensure to do IISReset after the services starts
        Ensure to reboot the server
        Ensure to have the available space on DB server and SP server.

http://expertsharepoint.blogspot.de/2014/03/user-profile-synchronization-service.html

The Sync DB is not supported for migration, for instance via mirroring to a standby farm. In these situations you need to build the User Profile service specifying only the Social and the Profile databases, the Sync database must be built new as it is farm specific.

You'll need to delete your user profile service application, delete the Sync database, then re-create the User Profile specifying the old Social and Profile DB and a brand new Sync DB.

Paul.

It's working perfectly with a new User Profile Service and new Sync DB, old Social db and old Profile DB.

The profiles and the properties are now in PROD server

Thank you everyone for your help.