Overview / Purpose 

In support we do receive calls about the versions/builds of Microsoft SQL Server that are supported as a backend SQL Server for the Synchronization Service Engine, and the FIM Service Database.  This wiki page is to help breakdown the builds of the Identity Management product, and builds of SQL Server to help provide guidance in this area.

Chart Breakdown

MIIS 2003 Service Pack 2 - ( 3.2.1005, 3.2.1008, 3.2.1016 ) 

Build Type
  • SQL Server 2000 Service Pack 3a
  • SQL Server 2000 Service Pack 4
  • SQL Server 2005
  • SQL Server 2005 with Service Packs
Enterprise, Standard, Developer 

IIFP Service Pack 2 - ( 3.2.1005, 3.2.1008 )

BuildType
Build Type
  • SQL Server 2000 Service Pack 3a
  • SQL Server 2000 Service Pack 4
  • SQL Server 2005
  • SQL Server 2005 with Service Packs
  Enterprise, Standard, Developer

ILM 2007 RTM - ( 3.2.559 )

BuildType
Build Type
  • SQL Server 2000 Service Pack 3a
  • SQL Server 2000 Service Pack 4
  • SQL Server 2005
  • SQL Server 2005 with Service Packs
  Enterprise, Standard, Developer

ILM 2007 Feature Pack 1 - ( 3.3.0118.2 through 3.3.1139.2 )

Build Type
  • SQL Server 2000 Service Pack 4
  • SQL Server 2005 Service Pack 2 or later 
  Enterprise, Standard, Developer

ILM 2007 Feature Pack 1 Service Pack 1 (3.3.1139.2 and later)

Build Type
  • SQL Server 2005 Service Pack 1 - 4
  • SQL Server 2008
  • SQL Server 2008 Service Pack 1 - 2 or later
  Enterprise, Standard, Developer
  

ILM 2007 Feature Pack 1 Service Pack 1 (3.3.1160.2, 3.3.1166.2, 3.3.1169.2)

  
Build Type
  • SQL Server 2005 Service Pack 1 - 4
  • SQL Server 2008
  • SQL Server 2008 Service Pack 1
  • SQL Servewidthr 2008 R2
  Enterprise, Standard, Developer

FIM 2010

Build Type
  • SQL Server 2008 Service Pack 1 or later
  • SQL Server 2008 R2
  • SQL Server 2008 R2 Service Pack 1 or later
  Enterprise, Standard, Developer

FIM 2010 R2

Build Type
  • SQL Server 2008 R2
  • SQL Server 2008 R2 Service Pack 1 or later
  Enterprise, Standard, Developer

FIM 2010 R2 SP1 BuildType

Build Type
  • SQL Server 2008 R2
  • SQL Server 2008 R2 Service Pack 1 or later
  • SQL Server 2012
  Enterprise, Standard, Developer

MIM 2016

Build Type
  • SQL Server 2008 R2 SP3 (Sync, Service, Reporting, BHOLD)
  • SQL Server 2012 SP2 (Sync, Service, Reporting, BHOLD)
  • SQL Server 2014 SP1 (Sync and Service only)
  Enterprise, Standard, Developer

Versions of SQL Server

See Also