User Profile Synchronization was working ok and after one restart FIM Synchronization Services fails to start and User Profile Synchronization won't start.
I have follow harbar.net article for setting up User Profile Synchronization Rational Guide to implementing SharePoint Server 2010 User Profile Synchronization
I read all Common Issues and didn't find answer for my case in this article Stuck on Starting: Common Issues with SharePoint Server 2010 User Profile Synchronization
Stuck on Starting and ULS logs event 9i1w: ILM Configuration: Error ‘ERR_CONFIG_DB’
This is due to insufficient privileges for the SharePoint Farm Account on the Sync DB (not the Config DB!). You need to add the farm account to the Sync DB users as DBO with a default schema of DBO and then start UPS again.
I had exactly the same eventID in ULS log (9i1w) with ILM Configuration: Error. Farm account was already there in Sync DB users.
And i have this error.
UserProfileApplication.SynchronizeMIIS: Failed to configure MIIS post database, will attempt during next rerun...