[Troubleshooting] Error 25009.The Forefront Identity Manager Synchronization Service setup wizard cannot configure the specified database

[Troubleshooting] Error 25009.The Forefront Identity Manager Synchronization Service setup wizard cannot configure the specified database


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 FIMSynchronizationServiceDB;
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

Leave a Comment
  • Please add 8 and 4 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Richard Mueller edited Revision 5. Comment: Added tags

Page 1 of 1 (1 items)