As you can read I was fighting with user profile service for SharePoint 2010. Today I faced a new problem. With new SharePoint installation I’ve created new service application for user profiles. No problem. Now it’s time to start User Profile Service… A few minutes and nothing??? What’s going on? Entry in SharePoint logs or windows logs has some strange entries like this:

The Forefront Identity Manager Service cannot connect to the SQL Database Server.

Microsoft.ResourceManagement.Service: System.TypeInitializationException: The type initializer for ‘Microsoft.ResourceManagement.WebServices.ResourceManagementServiceHostFactory’ threw an exception. —> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.TypeInitializationException: The type initializer for ‘Microsoft.ResourceManagement.WebServices.ResourceManagementServiceSection’ threw an exception. —> System.Configuration.ConfigurationErrorsException: Required attribute ‘externalHostName’ not found….

When I try to start manually Forefront Identity Manager Synchronization Service after a few minutes I get an error that  some files are missing. What’s up?

The clue was that I was trying to do my SharePoint installation more secure and I used two different accounts: one for SharePoint installation and the second for SharePoint farm, which is later marked as system account.

When I’ve added my farm account to local administrator group SharePoint was able to configure user profile service without any problem.