Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (bMicrosof)
  • When: 3 Dec 2012 12:22 PM
  • Last revision by (bMicrosof)
  • When: 4 Jul 2013 4:26 PM
  • Revisions: 8
  • Comments: 1
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  [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

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

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

, , , , , , , , , , , , , , , [Edit tags]
Leave a Comment
  • Please add 3 and 6 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
  • Posted by
    on 4 Apr 2013 3:52 PM

    Richard Mueller edited Revision 5. Comment: Added tags

Page 1 of 1 (1 items)