Table of Contents

Overview

Recently worked on an upgrade issue, where we were upgrading from Forefront Identity Manager 2010 (FIM 2010) to Forefront Identity Manager 2010 R2 (FIM 2010 R2).  In doing so, the FIM Synchronization Service fails with the Error 25009.  After clicking ok to the error message, the installation rolls back.

Windows Installer Verbose Log

Error 25009. 
The Forefront Identity Manager Synchronization Service setup wizard cannot configure the specified database. 
Cannot create more than one clustered index on table 'dbo.mms_connectorspace'. 
Drop the existing clustered index '_dta_index_mms_connectorspace_c_13_85575343__K1' before creating another. 
MSI (s) (7C!24) [08:51:56:786]: Product: Forefront Identity Manager Synchronization Service -- 
Error 25009.The Forefront Identity Manager Synchronization Service setup wizard cannot configure the specified database. 
Cannot create more than one clustered index on table 'dbo.mms_connectorspace'. 
Drop the existing clustered index '_dta_index_mms_connectorspace_c_13_85575343__K1' before creating another.

Troubleshooting 

Resolution

To resolve the issue we needed to remove the clustered index.  We can accomplish this task through the following SQL Query.

USE FIMSynchronizationService; 
GO DROP INDEX _dta_index_mms_connectorspace_c_13_85575343__K1 ON dbo.mms_connectorspace; 
GO 

See also

FIM Landing Page: Resource Wiki and Troubleshooter Wiki Index Page