4 thoughts on “SharePoint 2010 – User Profile Sync Error: ERR_Config_DB

  1. Pingback: SQL Alias and Synchronization Database « Sladescross's Blog

  2. Hi,
    I also took the idea of Spencer and crated the UPS application and also my User Profile Synchronization Service started successfully but unfortunately I am unable to create a Synchronization Connection and it shows an error

    “An error has occurred while accessing the SQL Server database or the SharePoint Server Search service. If this is the first time you have seen this message, try again later. If this problem persists, contact your administrator.”

    When I started the User Profile Synchronization Service; I captured the following log

    User Profile Application: Begin synchronizing profile property display names for language lcid = ‘1033’.
    User Profile Application: Done synchronizing profile property display names for language lcid = ‘1033’.
    Provisioning service instance User Profile Synchronization Service.
    The service instance User Profile Synchronization Service is successfully provisioned.
    SetupSynchronizationService :: Sync DB failover Check :: databaseServerMiis = XXXXXXXXXXXXX
    SetupSynchronizationService :: Sync DB failover Check :: originalSyncConnectionString = Data Source=XXXXXXXXXXXXX;Initial Catalog=”XXXXXXXXXXXXX”;Integrated Security=True;Enlist=False;Connect Timeout=15
    SetupSynchronizationService :: Sync DB failover Check:: originalSyncConnectionDataSource = XXXXXXXXXXXXX
    SetupSynchronizationService :: Sync DB failover Check :: new datasource string on connection object = XXXXXXXXXXXXX
    UserProfileApplication.SynchronizeMIIS: Begin setup for ‘XXXXXXXXXXXXX’.
    ILMPostSetupConfiguration: ILM Configuration: Validating installation of SQL Service.
    ILM Configuration: Error ‘ERR_SERVICE_NOT_INSTALLED’.
    ERROR ILMPostSetupConfiguration: ILM Configuration: Validating installation of SQL Service FAILED
    ILM Configuration: Validating account.
    ILM Configuration: Validating the system groups
    ILM Configuration: Setting up WMI
    ILM Configuration: Setting required permissions
    ILM Configuration: Create install config file
    ILM Configuration: Update source project
    ILM Configuration: Changing service account credentials
    ILM Configuration: Setting policy for service account
    ILM Configuration: Configuring database
    ILM Configuration: Re-starting mms service
    ILM Configuration: Checking mms service
    ILM Configuration: Configuring XML file.
    ILM Configuration: Checking for existing FIM database.
    ILM Configuration: Building database.
    User Profile Application: Begin synchronizing profile property display names for language lcid = ‘1033’.
    User Profile Application: Done synchronizing profile property display names for language lcid = ‘1033’.
    ILM Configuration: Configuring certificate.
    ILM Configuration: Configuring Registry keys.
    ILM Configuration: Setting file permissions.
    ILM Configuration: Opening firewall ports.
    ILM Configuration: Starting services.
    ILM Configuration: Post setup configuration.
    Synchronization database was not previously initialized. Exporting the encryption key from the registry key to the database
    ILM Configuration: The ExportMiisEncryptionKey process completed successfully
    UpdateILMMA: Updated ‘ILMMA’ credentials
    UpdateStoreAndCredentialsForInitialManagementAgents: ILMMachine XXXXXXXXXXXXX, Username XXXXXXXXXXXXX
    UpdateStoreAndCredentialsForInitialManagementAgents: Updated ‘MOSS-XXXXXXXXXXXXX’ credentials
    UserProfileApplication.SynchronizeMIIS: End setup for ‘(WoH PROD) User Profile Service Application 2’.
    User Profile Application: Begin synchronizing profile property display names for language lcid = ‘1033’.
    User Profile Application: Done synchronizing profile property display names for language lcid = ‘1033’.

    As you can see in the logs; you can see
    ILM Configuration: Error ‘ERR_SERVICE_NOT_INSTALLED’.
    and related errors.

    Any help would be appreciated.

  3. Pingback: SharePoint 2010 – User Profile Sync and SQL Named instances - Lionel van Leeuwaarde

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s