While performing a database attach upgrade from SharePoint Server 2007 to 2010 with this article
http://technet.microsoft.com/nl-nl/library/cc263299(en-us).aspx as my guide, I'm stuck at the 'Start the User Profile Synchronisation Service' section. When I use Central
Administration to start the service, after a few minutes being on the status 'Starting' it reverts back to 'Stopped'.
When reviewing the logs I find the following error message:
UserProfileApplication.SynchronizeMIIS: Failed to configure ILM, will attempt during next rerun. Exception: System.Data.SqlClient.SqlException: Specified collection 'StringSchemaCollection' cannot be dropped because it is used by object '<DOMAIN>\<FARM
The account used is already added to the local administrators group.
One solution I did find is in the following thread:
http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/58a404c0-af55-476c-84ad-8720de0a3292. The problem I have with this solution is that I should manually modify the user profile database, setting the correct default schem
View Complete Post