Synchronization Service Installation Failure - Error 25009 - sp_dbcmptlevel

Hello,

The title pretty much explains it all. I'm using SQL Server 2014 as a remote hosting DB server. I have the FIM Service and Portal installed and had no issues. But when installing the Synchronization Service, specifying the same DB server as the FIM Service and Portal, I get the following error:

Error 25009.  The Forefront Identity Manager Synchronization Service setup iszard cannot configure the specified database.  Usage: sp_dbcmptlevel [dbname [, compatibilitylevel]].  I get this message at the very end of the install process.

I would imagine I'm going to get an answer that the synchronization service is not support on SQL Server 2014, but I'm looking for a workaround.  The only think I can think of is the synchronization service database is supposed to run in a compatibility mode no longer support by SQL Server 2014.

But, I checked the installation I have on SQL Server 2008 R2 and the Synchronization service database is running is 2008 compatibility mode, just like the FIM Server db on the SQL Server 2014 installation.

Anyone have any ideas?


  • Edited by Greg Wilkerson Friday, May 15, 2015 2:55 PM Added information
May 15th, 2015 2:52pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics