none
Supported SQL Server version for MIM 2016 RRS feed

  • Question

  • Hi,

    We are planning to upgrade from FIM 2010 R2 to the latest version of MIM. We are mainly using FIM Synchronization service and the database server is currently on SQL Server 2012.

    Is there official support for MIM to work reliably with the latest service pack of SQL Server 2012 (currently SP4)?

    This link (https://docs.microsoft.com/en-us/microsoft-identity-manager/microsoft-identity-manager-2016-supported-platforms) lists SQL Server 2012 SP2 for the MIM Sync database.

    Does that mean that only SP2 and HIGHER service packs of SQL Server 2012 are supported by MIM?

    Or, does this mean that only SP2 and LOWER service packs of SQL Server 2012 are supported by MIM?

    All Microsoft support for SQL Server 2012 SP2 and older has already ended in 2017, including extended support. SQL Server 2012 SP4 still has extended support.

    I am wondering if it'd be safe to upgrade SQL Server to 2012 with SP4 and use it for in-place upgrade to MIM.

    Best regards,
    Radu Popa


    Radu Popa

    Friday, June 22, 2018 7:30 PM

All replies

  • They almost always mean that SP and above. But never assume that they mean the next major version is supported too. So SQL 2012 SP2 and above are supported but until they announced support for SQL 2014 and 2016 I didn't assume they were supported.

    David Lundell, Get your copy of FIM Best Practices Volume 1 http://blog.ilmbestpractices.com/2010/08/book-is-here-fim-best-practices-volume.html

    Friday, August 3, 2018 3:54 PM
  • Thanks for the clarification David!

    in the meantime we've upgraded SQL Server to 2012 with SP4 and used it for in-place upgrade to MIM.

    We're only using the Sync engine and it worked fine.

    Cheers,


    Radu Popa

    Tuesday, August 14, 2018 6:02 PM