User profile Synchronisation service is not provisioned

• Login as farm account
• Backup the User Profile DB and the User Profile Sync DB
• Stop the SharePoint 2010 Timer service
• Delete the data in the Sync DB using the following PowerShell commands (This is not a script. So please cut and paste each of these commands one by one):

Get-SPDatabase (Copy the GUID associated with the User Profile Sync DB)

$syncdb=Get-SPDatabase –Id <GUID>

$syncdb.Unprovision()

$syncdb.Status='Offline'

Get-SPServiceApplication (Copy the GUID associated with the User Profile Service)

$upa=Get-SPServiceApplication –Id <GUID>

$upa.ResetSynchronizationMachine()

$upa.ResetSynchronizationDatabase()

• Provision the Sync DB:

$syncdb.Provision()

• Add the User Profile Synchronization service account (farm account) as the dbowner on the Sync DB (using SQL Server Management Studio).
• Start the SharePoint 2010 Timer service
• Start the User Profile Synchronization Service in the Central Administration UI.
• After the User Profile Synchronization Service is started, reset IIS.
• Create connections to data sources in the Central Administration UI.

 

Mots clés Technorati : SharePoint 2010,User Profile Synchronization