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.
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
FIM Landing Page: Resource Wiki and Troubleshooter Wiki Index Page